{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "9358a09c",
   "metadata": {},
   "outputs": [],
   "source": [
    "import akshare as ak"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "5d18bc2e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.microsoft.datawrangler.viewer.v0+json": {
       "columns": [
        {
         "name": "index",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "name",
         "rawType": "object",
         "type": "string"
        },
        {
         "name": "code",
         "rawType": "object",
         "type": "string"
        }
       ],
       "ref": "7d582653-17ed-4e02-9552-bb65dd2fdd43",
       "rows": [
        [
         "0",
         "A",
         "A"
        ],
        [
         "1",
         "A+",
         "A+"
        ],
        [
         "2",
         "A-",
         "A-"
        ],
        [
         "3",
         "A-1",
         "A-1"
        ],
        [
         "4",
         "A-2",
         "A-2"
        ],
        [
         "5",
         "A-3",
         "A-3"
        ],
        [
         "6",
         "AA",
         "AA"
        ],
        [
         "7",
         "AA+",
         "AA+"
        ],
        [
         "8",
         "AA-",
         "AA-"
        ],
        [
         "9",
         "AAA",
         "AAA"
        ],
        [
         "10",
         "AAA+",
         "AAA+"
        ],
        [
         "11",
         "AAA-",
         "AAA-"
        ],
        [
         "12",
         "B",
         "B"
        ],
        [
         "13",
         "B+",
         "B+"
        ],
        [
         "14",
         "B-",
         "B-"
        ],
        [
         "15",
         "BB",
         "BB"
        ],
        [
         "16",
         "BB+",
         "BB+"
        ],
        [
         "17",
         "BB-",
         "BB-"
        ],
        [
         "18",
         "BBB",
         "BBB"
        ],
        [
         "19",
         "BBB+",
         "BBB+"
        ],
        [
         "20",
         "BBB-",
         "BBB-"
        ],
        [
         "21",
         "C",
         "C"
        ],
        [
         "22",
         "CC",
         "CC"
        ],
        [
         "23",
         "CCC",
         "CCC"
        ],
        [
         "24",
         "CCC+",
         "CCC+"
        ],
        [
         "25",
         "CCC-",
         "CCC-"
        ],
        [
         "26",
         "D",
         "D"
        ]
       ],
       "shape": {
        "columns": 2,
        "rows": 27
       }
      },
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>A+</td>\n",
       "      <td>A+</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>A-</td>\n",
       "      <td>A-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>A-1</td>\n",
       "      <td>A-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>A-2</td>\n",
       "      <td>A-2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>A-3</td>\n",
       "      <td>A-3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>AA</td>\n",
       "      <td>AA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>AA+</td>\n",
       "      <td>AA+</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>AA-</td>\n",
       "      <td>AA-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>AAA</td>\n",
       "      <td>AAA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>AAA+</td>\n",
       "      <td>AAA+</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>AAA-</td>\n",
       "      <td>AAA-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>B</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>B+</td>\n",
       "      <td>B+</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>B-</td>\n",
       "      <td>B-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>BB</td>\n",
       "      <td>BB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>BB+</td>\n",
       "      <td>BB+</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>BB-</td>\n",
       "      <td>BB-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>BBB</td>\n",
       "      <td>BBB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>BBB+</td>\n",
       "      <td>BBB+</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>BBB-</td>\n",
       "      <td>BBB-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>C</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>CC</td>\n",
       "      <td>CC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>CCC</td>\n",
       "      <td>CCC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>CCC+</td>\n",
       "      <td>CCC+</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>CCC-</td>\n",
       "      <td>CCC-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>D</td>\n",
       "      <td>D</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    name  code\n",
       "0      A     A\n",
       "1     A+    A+\n",
       "2     A-    A-\n",
       "3    A-1   A-1\n",
       "4    A-2   A-2\n",
       "5    A-3   A-3\n",
       "6     AA    AA\n",
       "7    AA+   AA+\n",
       "8    AA-   AA-\n",
       "9    AAA   AAA\n",
       "10  AAA+  AAA+\n",
       "11  AAA-  AAA-\n",
       "12     B     B\n",
       "13    B+    B+\n",
       "14    B-    B-\n",
       "15    BB    BB\n",
       "16   BB+   BB+\n",
       "17   BB-   BB-\n",
       "18   BBB   BBB\n",
       "19  BBB+  BBB+\n",
       "20  BBB-  BBB-\n",
       "21     C     C\n",
       "22    CC    CC\n",
       "23   CCC   CCC\n",
       "24  CCC+  CCC+\n",
       "25  CCC-  CCC-\n",
       "26     D     D"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bond_info_cm_df = ak.bond_info_cm_query()\n",
    "bond_info_cm_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "a57c45b7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.microsoft.datawrangler.viewer.v0+json": {
       "columns": [
        {
         "name": "index",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "item",
         "rawType": "object",
         "type": "string"
        },
        {
         "name": "value",
         "rawType": "object",
         "type": "string"
        }
       ],
       "ref": "73afabda-274f-4f06-b239-b337b9e63008",
       "rows": [
        [
         "0",
         "债券名称",
         "万科企业股份有限公司2022年面向专业投资者公开发行公司债券(第四期)(品种一)"
        ],
        [
         "1",
         "债券简称",
         "22万科07"
        ],
        [
         "2",
         "债券代码",
         "sz148099"
        ],
        [
         "3",
         "债券类型",
         "普通企业债"
        ],
        [
         "4",
         "债券面值（元）",
         "100"
        ],
        [
         "5",
         "债券年限（年）",
         "5"
        ],
        [
         "6",
         "票面利率（%）",
         "3.45"
        ],
        [
         "7",
         "到期日",
         "2025-10-31"
        ],
        [
         "8",
         "兑付日",
         "2025-10-31"
        ],
        [
         "9",
         "摘牌日",
         "--"
        ],
        [
         "10",
         "计息方式",
         "固定利率"
        ],
        [
         "11",
         "利率说明",
         "本期债券票面利率为固定利率，票面利率将根据网下询价簿记结果，由公司与簿记管理人按照有关规定，在利率询价区间内协商一致确定。债券票面利率采取单利按年计息，不计复利。本期债券品种一票面利率询价区间为3.00%-4.00%，本期债券最终票面利率将由发行人和簿记管理人根据簿记建档结果确定。"
        ],
        [
         "12",
         "付息方式",
         "周期性付息"
        ],
        [
         "13",
         "起息日期",
         "2022-10-31"
        ],
        [
         "14",
         "止息日期",
         "2025-10-30"
        ],
        [
         "15",
         "付息日期",
         "10-31"
        ],
        [
         "16",
         "年付息次数",
         "1"
        ],
        [
         "17",
         "发行价格（元）",
         "100"
        ],
        [
         "18",
         "发行规模（亿元）",
         "25"
        ],
        [
         "19",
         "发行日期",
         "2022-10-28"
        ],
        [
         "20",
         "上市日期",
         "2022-11-04"
        ],
        [
         "21",
         "上市场所",
         "深圳交易所"
        ],
        [
         "22",
         "信用等级",
         "AAA"
        ],
        [
         "23",
         "内部信用增级方式",
         "--"
        ],
        [
         "24",
         "外部信用增级方式",
         "--"
        ]
       ],
       "shape": {
        "columns": 2,
        "rows": 25
       }
      },
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>item</th>\n",
       "      <th>value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>债券名称</td>\n",
       "      <td>万科企业股份有限公司2022年面向专业投资者公开发行公司债券(第四期)(品种一)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>债券简称</td>\n",
       "      <td>22万科07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>债券代码</td>\n",
       "      <td>sz148099</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>债券类型</td>\n",
       "      <td>普通企业债</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>债券面值（元）</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>债券年限（年）</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>票面利率（%）</td>\n",
       "      <td>3.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>到期日</td>\n",
       "      <td>2025-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>兑付日</td>\n",
       "      <td>2025-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>摘牌日</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>计息方式</td>\n",
       "      <td>固定利率</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>利率说明</td>\n",
       "      <td>本期债券票面利率为固定利率，票面利率将根据网下询价簿记结果，由公司与簿记管理人按照有关规定，...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>付息方式</td>\n",
       "      <td>周期性付息</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>起息日期</td>\n",
       "      <td>2022-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>止息日期</td>\n",
       "      <td>2025-10-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>付息日期</td>\n",
       "      <td>10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>年付息次数</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>发行价格（元）</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>发行规模（亿元）</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>发行日期</td>\n",
       "      <td>2022-10-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>上市日期</td>\n",
       "      <td>2022-11-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>上市场所</td>\n",
       "      <td>深圳交易所</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>信用等级</td>\n",
       "      <td>AAA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>内部信用增级方式</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>外部信用增级方式</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        item                                              value\n",
       "0       债券名称           万科企业股份有限公司2022年面向专业投资者公开发行公司债券(第四期)(品种一)\n",
       "1       债券简称                                             22万科07\n",
       "2       债券代码                                           sz148099\n",
       "3       债券类型                                              普通企业债\n",
       "4    债券面值（元）                                                100\n",
       "5    债券年限（年）                                                  5\n",
       "6    票面利率（%）                                               3.45\n",
       "7        到期日                                         2025-10-31\n",
       "8        兑付日                                         2025-10-31\n",
       "9        摘牌日                                                 --\n",
       "10      计息方式                                               固定利率\n",
       "11      利率说明  本期债券票面利率为固定利率，票面利率将根据网下询价簿记结果，由公司与簿记管理人按照有关规定，...\n",
       "12      付息方式                                              周期性付息\n",
       "13      起息日期                                         2022-10-31\n",
       "14      止息日期                                         2025-10-30\n",
       "15      付息日期                                              10-31\n",
       "16     年付息次数                                                  1\n",
       "17   发行价格（元）                                                100\n",
       "18  发行规模（亿元）                                                 25\n",
       "19      发行日期                                         2022-10-28\n",
       "20      上市日期                                         2022-11-04\n",
       "21      上市场所                                              深圳交易所\n",
       "22      信用等级                                                AAA\n",
       "23  内部信用增级方式                                                 --\n",
       "24  外部信用增级方式                                                 --"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bond_cb_profile_sina_df = ak.bond_cb_profile_sina(symbol=\"sz148099\")\n",
    "bond_cb_profile_sina_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "f7297266",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.microsoft.datawrangler.viewer.v0+json": {
       "columns": [
        {
         "name": "index",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "item",
         "rawType": "object",
         "type": "string"
        },
        {
         "name": "value",
         "rawType": "object",
         "type": "string"
        }
       ],
       "ref": "c84dfbcc-326a-419e-ae41-675114b38a66",
       "rows": [
        [
         "0",
         "债券类型",
         "普通企业债"
        ],
        [
         "1",
         "计息方式",
         "固定利率"
        ],
        [
         "2",
         "付息方式",
         "周期性付息"
        ],
        [
         "3",
         "票面利率（%）",
         "3.45"
        ],
        [
         "4",
         "每年付息日",
         "10-31"
        ],
        [
         "5",
         "发行价格（元）",
         "100"
        ],
        [
         "6",
         "发行规模（亿元）",
         "25"
        ],
        [
         "7",
         "债券面值（元）",
         "100"
        ],
        [
         "8",
         "债券年限（年）",
         "5"
        ],
        [
         "9",
         "到期日期",
         "2025-10-31"
        ],
        [
         "10",
         "全价（元）",
         "--"
        ],
        [
         "11",
         "剩余年限（年）",
         "0.05"
        ],
        [
         "12",
         "到期收益率（%）",
         "--"
        ],
        [
         "13",
         "修正久期",
         "--"
        ],
        [
         "14",
         "凸性",
         "--"
        ]
       ],
       "shape": {
        "columns": 2,
        "rows": 15
       }
      },
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>item</th>\n",
       "      <th>value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>债券类型</td>\n",
       "      <td>普通企业债</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>计息方式</td>\n",
       "      <td>固定利率</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>付息方式</td>\n",
       "      <td>周期性付息</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>票面利率（%）</td>\n",
       "      <td>3.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>每年付息日</td>\n",
       "      <td>10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>发行价格（元）</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>发行规模（亿元）</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>债券面值（元）</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>债券年限（年）</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>到期日期</td>\n",
       "      <td>2025-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>全价（元）</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>剩余年限（年）</td>\n",
       "      <td>0.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>到期收益率（%）</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>修正久期</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>凸性</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        item       value\n",
       "0       债券类型       普通企业债\n",
       "1       计息方式        固定利率\n",
       "2       付息方式       周期性付息\n",
       "3    票面利率（%）        3.45\n",
       "4      每年付息日       10-31\n",
       "5    发行价格（元）         100\n",
       "6   发行规模（亿元）          25\n",
       "7    债券面值（元）         100\n",
       "8    债券年限（年）           5\n",
       "9       到期日期  2025-10-31\n",
       "10     全价（元）          --\n",
       "11   剩余年限（年）        0.05\n",
       "12  到期收益率（%）          --\n",
       "13      修正久期          --\n",
       "14        凸性          --"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bond_cb_summary_sina_df = ak.bond_cb_summary_sina(symbol=\"sz148099\")\n",
    "bond_cb_summary_sina_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "a01ad2a2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "ccc5f5b4c8b042bba5b590f39e171205",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "  0%|          | 0/6 [00:00<?, ?it/s]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "bond_zh_hs_cov_spot_df = ak.bond_zh_hs_cov_spot()\n",
    "bond_symbol_and_name = bond_zh_hs_cov_spot_df[['symbol','name']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "cceea9e6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.microsoft.datawrangler.viewer.v0+json": {
       "columns": [
        {
         "name": "index",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "date",
         "rawType": "object",
         "type": "unknown"
        },
        {
         "name": "open",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "high",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "low",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "close",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "volume",
         "rawType": "int64",
         "type": "integer"
        }
       ],
       "ref": "fd090584-d986-4e80-9ad8-e23b577f2e40",
       "rows": [
        [
         "0",
         "2022-11-04",
         "100.0",
         "100.0",
         "100.0",
         "100.0",
         "3000000"
        ],
        [
         "1",
         "2022-11-09",
         "98.067",
         "98.476",
         "98.067",
         "98.476",
         "1800000"
        ],
        [
         "2",
         "2022-11-10",
         "98.014",
         "98.34",
         "98.014",
         "98.34",
         "1600000"
        ],
        [
         "3",
         "2022-12-01",
         "97.306",
         "97.306",
         "97.306",
         "97.306",
         "500000"
        ],
        [
         "4",
         "2022-12-06",
         "97.317",
         "97.317",
         "97.317",
         "97.317",
         "500000"
        ],
        [
         "5",
         "2022-12-16",
         "97.003",
         "97.003",
         "97.003",
         "97.003",
         "800000"
        ],
        [
         "6",
         "2022-12-21",
         "98.43",
         "98.431",
         "98.43",
         "98.431",
         "1000000"
        ],
        [
         "7",
         "2022-12-22",
         "98.432",
         "98.432",
         "97.482",
         "97.482",
         "1000000"
        ],
        [
         "8",
         "2022-12-26",
         "97.614",
         "97.614",
         "97.614",
         "97.614",
         "500000"
        ],
        [
         "9",
         "2022-12-27",
         "97.751",
         "97.751",
         "97.751",
         "97.751",
         "1400000"
        ],
        [
         "10",
         "2022-12-29",
         "97.806",
         "97.806",
         "97.806",
         "97.806",
         "600000"
        ],
        [
         "11",
         "2022-12-30",
         "97.808",
         "97.808",
         "97.808",
         "97.808",
         "500000"
        ],
        [
         "12",
         "2023-01-04",
         "97.815",
         "98.385",
         "97.815",
         "98.385",
         "800000"
        ],
        [
         "13",
         "2023-02-08",
         "98.583",
         "98.583",
         "98.583",
         "98.583",
         "200000"
        ],
        [
         "14",
         "2023-03-29",
         "99.611",
         "99.617",
         "99.611",
         "99.617",
         "1000000"
        ],
        [
         "15",
         "2023-05-30",
         "100.436",
         "100.443",
         "100.436",
         "100.443",
         "1000000"
        ],
        [
         "16",
         "2023-06-12",
         "100.446",
         "100.446",
         "100.446",
         "100.446",
         "500000"
        ],
        [
         "17",
         "2023-06-13",
         "100.446",
         "100.447",
         "100.446",
         "100.447",
         "1000000"
        ],
        [
         "18",
         "2023-08-29",
         "100.802",
         "100.802",
         "100.802",
         "100.802",
         "1000000"
        ],
        [
         "19",
         "2023-09-12",
         "97.89",
         "97.89",
         "97.89",
         "97.89",
         "500000"
        ],
        [
         "20",
         "2023-09-25",
         "98.383",
         "98.39",
         "98.383",
         "98.39",
         "1000000"
        ],
        [
         "21",
         "2023-11-27",
         "87.0",
         "87.0",
         "87.0",
         "87.0",
         "100000"
        ],
        [
         "22",
         "2023-12-04",
         "88.0",
         "88.0",
         "88.0",
         "88.0",
         "100000"
        ],
        [
         "23",
         "2023-12-06",
         "90.0",
         "90.0",
         "90.0",
         "90.0",
         "100000"
        ],
        [
         "24",
         "2023-12-07",
         "88.65",
         "88.7",
         "88.65",
         "88.7",
         "200000"
        ],
        [
         "25",
         "2023-12-11",
         "97.5",
         "97.51",
         "97.5",
         "97.51",
         "200000"
        ],
        [
         "26",
         "2023-12-20",
         "90.47",
         "90.5",
         "90.47",
         "90.5",
         "200000"
        ],
        [
         "27",
         "2024-02-01",
         "94.415",
         "94.415",
         "94.415",
         "94.415",
         "1500000"
        ],
        [
         "28",
         "2024-02-20",
         "79.5",
         "79.5",
         "79.5",
         "79.5",
         "1000"
        ],
        [
         "29",
         "2024-02-21",
         "79.5",
         "90.0",
         "79.5",
         "90.0",
         "11000"
        ],
        [
         "30",
         "2024-02-23",
         "90.0",
         "90.0",
         "90.0",
         "90.0",
         "1000"
        ],
        [
         "31",
         "2024-03-12",
         "73.0",
         "79.9",
         "73.0",
         "79.5",
         "50000"
        ],
        [
         "32",
         "2024-03-18",
         "76.0",
         "80.0",
         "76.0",
         "80.0",
         "120000"
        ],
        [
         "33",
         "2024-03-25",
         "73.0",
         "73.0",
         "73.0",
         "73.0",
         "3000"
        ],
        [
         "34",
         "2024-03-26",
         "73.008",
         "73.01",
         "73.008",
         "73.01",
         "20000"
        ],
        [
         "35",
         "2024-03-29",
         "76.985",
         "76.985",
         "76.985",
         "76.985",
         "550000"
        ],
        [
         "36",
         "2024-04-03",
         "73.112",
         "75.0",
         "73.1",
         "73.1",
         "7000"
        ],
        [
         "37",
         "2024-04-08",
         "76.106",
         "76.106",
         "76.106",
         "76.106",
         "550000"
        ],
        [
         "38",
         "2024-04-11",
         "69.004",
         "72.47",
         "69.004",
         "70.0",
         "45000"
        ],
        [
         "39",
         "2024-04-16",
         "68.007",
         "68.007",
         "68.0",
         "68.0",
         "12000"
        ],
        [
         "40",
         "2024-04-17",
         "69.0",
         "69.0",
         "69.0",
         "69.0",
         "1000"
        ],
        [
         "41",
         "2024-04-29",
         "66.66",
         "66.9",
         "66.66",
         "66.789",
         "26000"
        ],
        [
         "42",
         "2024-04-30",
         "66.7",
         "66.75",
         "66.692",
         "66.718",
         "7000"
        ],
        [
         "43",
         "2024-05-06",
         "68.0",
         "68.0",
         "68.0",
         "68.0",
         "6000"
        ],
        [
         "44",
         "2024-05-07",
         "68.0",
         "68.0",
         "68.0",
         "68.0",
         "1000"
        ],
        [
         "45",
         "2024-05-08",
         "68.0",
         "68.0",
         "68.0",
         "68.0",
         "1000"
        ],
        [
         "46",
         "2024-05-09",
         "68.0",
         "68.0",
         "68.0",
         "68.0",
         "1000"
        ],
        [
         "47",
         "2024-05-10",
         "69.995",
         "70.0",
         "69.995",
         "69.997",
         "3000"
        ],
        [
         "48",
         "2024-05-13",
         "71.995",
         "72.495",
         "71.505",
         "71.505",
         "15000"
        ],
        [
         "49",
         "2024-05-14",
         "72.497",
         "75.0",
         "68.088",
         "68.159",
         "1646000"
        ]
       ],
       "shape": {
        "columns": 6,
        "rows": 382
       }
      },
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>open</th>\n",
       "      <th>high</th>\n",
       "      <th>low</th>\n",
       "      <th>close</th>\n",
       "      <th>volume</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022-11-04</td>\n",
       "      <td>100.000</td>\n",
       "      <td>100.000</td>\n",
       "      <td>100.000</td>\n",
       "      <td>100.000</td>\n",
       "      <td>3000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022-11-09</td>\n",
       "      <td>98.067</td>\n",
       "      <td>98.476</td>\n",
       "      <td>98.067</td>\n",
       "      <td>98.476</td>\n",
       "      <td>1800000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022-11-10</td>\n",
       "      <td>98.014</td>\n",
       "      <td>98.340</td>\n",
       "      <td>98.014</td>\n",
       "      <td>98.340</td>\n",
       "      <td>1600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022-12-01</td>\n",
       "      <td>97.306</td>\n",
       "      <td>97.306</td>\n",
       "      <td>97.306</td>\n",
       "      <td>97.306</td>\n",
       "      <td>500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022-12-06</td>\n",
       "      <td>97.317</td>\n",
       "      <td>97.317</td>\n",
       "      <td>97.317</td>\n",
       "      <td>97.317</td>\n",
       "      <td>500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>377</th>\n",
       "      <td>2025-09-26</td>\n",
       "      <td>99.999</td>\n",
       "      <td>99.999</td>\n",
       "      <td>99.850</td>\n",
       "      <td>99.897</td>\n",
       "      <td>416000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>378</th>\n",
       "      <td>2025-09-29</td>\n",
       "      <td>99.902</td>\n",
       "      <td>99.990</td>\n",
       "      <td>99.902</td>\n",
       "      <td>99.943</td>\n",
       "      <td>100000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>379</th>\n",
       "      <td>2025-09-30</td>\n",
       "      <td>99.999</td>\n",
       "      <td>99.999</td>\n",
       "      <td>99.999</td>\n",
       "      <td>99.999</td>\n",
       "      <td>1000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>380</th>\n",
       "      <td>2025-10-09</td>\n",
       "      <td>99.880</td>\n",
       "      <td>99.929</td>\n",
       "      <td>99.880</td>\n",
       "      <td>99.924</td>\n",
       "      <td>395400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>381</th>\n",
       "      <td>2025-10-10</td>\n",
       "      <td>99.924</td>\n",
       "      <td>99.925</td>\n",
       "      <td>99.905</td>\n",
       "      <td>99.918</td>\n",
       "      <td>231700</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>382 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           date     open     high      low    close   volume\n",
       "0    2022-11-04  100.000  100.000  100.000  100.000  3000000\n",
       "1    2022-11-09   98.067   98.476   98.067   98.476  1800000\n",
       "2    2022-11-10   98.014   98.340   98.014   98.340  1600000\n",
       "3    2022-12-01   97.306   97.306   97.306   97.306   500000\n",
       "4    2022-12-06   97.317   97.317   97.317   97.317   500000\n",
       "..          ...      ...      ...      ...      ...      ...\n",
       "377  2025-09-26   99.999   99.999   99.850   99.897   416000\n",
       "378  2025-09-29   99.902   99.990   99.902   99.943   100000\n",
       "379  2025-09-30   99.999   99.999   99.999   99.999     1000\n",
       "380  2025-10-09   99.880   99.929   99.880   99.924   395400\n",
       "381  2025-10-10   99.924   99.925   99.905   99.918   231700\n",
       "\n",
       "[382 rows x 6 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bond_zh_hs_cov_daily_df = ak.bond_zh_hs_cov_daily(symbol=\"sz148099\")\n",
    "bond_zh_hs_cov_daily_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "237ffda2",
   "metadata": {},
   "outputs": [
    {
     "ename": "TypeError",
     "evalue": "'NoneType' object is not subscriptable",
     "output_type": "error",
     "traceback": [
      "\u001b[31m---------------------------------------------------------------------------\u001b[39m",
      "\u001b[31mTypeError\u001b[39m                                 Traceback (most recent call last)",
      "\u001b[36mCell\u001b[39m\u001b[36m \u001b[39m\u001b[32mIn[14]\u001b[39m\u001b[32m, line 1\u001b[39m\n\u001b[32m----> \u001b[39m\u001b[32m1\u001b[39m bond_zh_cov_info_df = \u001b[43mak\u001b[49m\u001b[43m.\u001b[49m\u001b[43mbond_zh_cov_info\u001b[49m\u001b[43m(\u001b[49m\u001b[43msymbol\u001b[49m\u001b[43m=\u001b[49m\u001b[33;43m\"\u001b[39;49m\u001b[33;43msz148099\u001b[39;49m\u001b[33;43m\"\u001b[39;49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mindicator\u001b[49m\u001b[43m=\u001b[49m\u001b[33;43m\"\u001b[39;49m\u001b[33;43m基本信息\u001b[39;49m\u001b[33;43m\"\u001b[39;49m\u001b[43m)\u001b[49m\n\u001b[32m      2\u001b[39m bond_zh_cov_info_df\n",
      "\u001b[36mFile \u001b[39m\u001b[32m~/.conda/envs/fas/lib/python3.12/site-packages/akshare/bond/bond_zh_cov.py:586\u001b[39m, in \u001b[36mbond_zh_cov_info\u001b[39m\u001b[34m(symbol, indicator)\u001b[39m\n\u001b[32m    584\u001b[39m     r = requests.get(url, params=params)\n\u001b[32m    585\u001b[39m     data_json = r.json()\n\u001b[32m--> \u001b[39m\u001b[32m586\u001b[39m     temp_df = pd.DataFrame.from_dict(\u001b[43mdata_json\u001b[49m\u001b[43m[\u001b[49m\u001b[33;43m\"\u001b[39;49m\u001b[33;43mresult\u001b[39;49m\u001b[33;43m\"\u001b[39;49m\u001b[43m]\u001b[49m\u001b[43m[\u001b[49m\u001b[33;43m\"\u001b[39;49m\u001b[33;43mdata\u001b[39;49m\u001b[33;43m\"\u001b[39;49m\u001b[43m]\u001b[49m)\n\u001b[32m    587\u001b[39m     \u001b[38;5;28;01mreturn\u001b[39;00m temp_df\n\u001b[32m    588\u001b[39m \u001b[38;5;28;01melif\u001b[39;00m indicator == \u001b[33m\"\u001b[39m\u001b[33m中签号\u001b[39m\u001b[33m\"\u001b[39m:\n",
      "\u001b[31mTypeError\u001b[39m: 'NoneType' object is not subscriptable"
     ]
    }
   ],
   "source": [
    "bond_zh_cov_info_df = ak.bond_zh_cov_info(symbol=\"148099\", indicator=\"基本信息\")\n",
    "bond_zh_cov_info_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "2534c3cb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "85990dfa63d1427a87e8ea34acca3fdc",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "  0%|          | 0/4 [00:00<?, ?it/s]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/vnd.microsoft.datawrangler.viewer.v0+json": {
       "columns": [
        {
         "name": "index",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "序号",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "转债代码",
         "rawType": "object",
         "type": "string"
        },
        {
         "name": "转债名称",
         "rawType": "object",
         "type": "string"
        },
        {
         "name": "转债最新价",
         "rawType": "object",
         "type": "unknown"
        },
        {
         "name": "转债涨跌幅",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "正股代码",
         "rawType": "object",
         "type": "string"
        },
        {
         "name": "正股名称",
         "rawType": "object",
         "type": "string"
        },
        {
         "name": "正股最新价",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "正股涨跌幅",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "转股价",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "转股价值",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "转股溢价率",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "纯债溢价率",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "回售触发价",
         "rawType": "object",
         "type": "unknown"
        },
        {
         "name": "强赎触发价",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "到期赎回价",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "纯债价值",
         "rawType": "object",
         "type": "unknown"
        },
        {
         "name": "开始转股日",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "上市日期",
         "rawType": "object",
         "type": "unknown"
        },
        {
         "name": "申购日期",
         "rawType": "int64",
         "type": "integer"
        }
       ],
       "ref": "f86cf58a-4cfc-445f-8f3e-ae679d1a2dc2",
       "rows": [
        [
         "0",
         "1",
         "123118",
         "惠城转债",
         "1605.6",
         "20.0",
         "300779",
         "惠城环保",
         "170.88",
         "20.0",
         "11.11",
         "1538.0739",
         "4.39",
         "1380.76",
         "7.78",
         "14.44",
         "115.0",
         "108.4306",
         "20220113",
         "20210726",
         "20210707"
        ],
        [
         "1",
         "2",
         "118056",
         "路维转债",
         "214.921",
         "12.69",
         "688401",
         "路维光电",
         "58.32",
         "20.0",
         "32.7",
         "178.3486",
         "20.51",
         "128.83",
         "22.89",
         "42.51",
         "112.0",
         "93.9199",
         "20251217",
         "20250710",
         "20250611"
        ],
        [
         "2",
         "3",
         "110096",
         "豫光转债",
         "260.129",
         "11.95",
         "600531",
         "豫光金铅",
         "14.58",
         "10.04",
         "5.95",
         "245.042",
         "6.16",
         "153.12",
         "4.17",
         "7.74",
         "112.0",
         "102.7695",
         "20250217",
         "20240903",
         "20240812"
        ],
        [
         "3",
         "4",
         "128144",
         "利民转债",
         "265.834",
         "6.94",
         "002734",
         "利民股份",
         "20.8",
         "7.77",
         "8.1",
         "256.7901",
         "3.52",
         "144.65",
         "5.67",
         "10.53",
         "110.0",
         "108.6596",
         "20210906",
         "20210324",
         "20210301"
        ],
        [
         "4",
         "5",
         "123235",
         "亿田转债",
         "256.554",
         "6.11",
         "300911",
         "亿田智能",
         "54.2",
         "8.57",
         "21.31",
         "254.3407",
         "0.87",
         "143.15",
         "14.92",
         "27.7",
         "115.0",
         "105.5119",
         "20240627",
         "20240112",
         "20231221"
        ],
        [
         "5",
         "6",
         "110074",
         "精达转债",
         "400.05",
         "3.72",
         "600577",
         "XD精达股",
         "11.11",
         "2.11",
         "3.32",
         "334.6386",
         "19.55",
         "262.65",
         "2.32",
         "4.32",
         "112.0",
         "110.3134",
         "20210225",
         "20200921",
         "20200819"
        ],
        [
         "6",
         "7",
         "118058",
         "微导转债",
         "247.308",
         "3.26",
         "688147",
         "微导纳米",
         "54.03",
         "-1.78",
         "33.57",
         "160.9473",
         "53.66",
         "152.07",
         "23.5",
         "43.64",
         "110.0",
         "98.1111",
         "20260212",
         "20250827",
         "20250806"
        ],
        [
         "7",
         "8",
         "127076",
         "中宠转2",
         "235.678",
         "3.03",
         "002891",
         "中宠股份",
         "56.68",
         "3.05",
         "27.46",
         "206.4093",
         "14.18",
         "121.85",
         "19.22",
         "35.7",
         "112.0",
         "106.235",
         "20230504",
         "20221121",
         "20221025"
        ],
        [
         "8",
         "9",
         "118045",
         "盟升转债",
         "194.446",
         "3.01",
         "688311",
         "盟升电子",
         "35.79",
         "3.92",
         "20.94",
         "170.9169",
         "13.77",
         "124.72",
         "14.66",
         "27.22",
         "112.0",
         "86.5292",
         "20240318",
         "20231017",
         "20230912"
        ],
        [
         "9",
         "10",
         "123124",
         "晶瑞转2",
         "133.781",
         "2.99",
         "300655",
         "晶瑞电材",
         "16.49",
         "8.13",
         "16.7",
         "98.7425",
         "35.48",
         "34.04",
         "11.69",
         "21.71",
         "107.0",
         "99.8067",
         "20220221",
         "20210907",
         "20210816"
        ],
        [
         "10",
         "11",
         "127020",
         "中金转债",
         "141.58",
         "2.73",
         "000060",
         "中金岭南",
         "6.11",
         "3.21",
         "4.29",
         "142.4242",
         "-0.59",
         "30.43",
         "3.0",
         "5.58",
         "110.0",
         "108.5464",
         "20210125",
         "20200814",
         "20200720"
        ],
        [
         "11",
         "12",
         "123243",
         "严牌转债",
         "146.499",
         "2.65",
         "301081",
         "严牌股份",
         "10.36",
         "0.48",
         "7.27",
         "142.5034",
         "2.8",
         "59.73",
         "5.09",
         "9.45",
         "114.0",
         "91.7191",
         "20250116",
         "20240726",
         "20240710"
        ],
        [
         "12",
         "13",
         "118035",
         "国力转债",
         "145.561",
         "2.65",
         "688103",
         "国力电子",
         "77.17",
         "4.21",
         "62.54",
         "123.393",
         "17.97",
         "47.77",
         "43.78",
         "81.3",
         "115.0",
         "98.5076",
         "20231218",
         "20230706",
         "20230612"
        ],
        [
         "13",
         "14",
         "127081",
         "中旗转债",
         "393.2",
         "2.4",
         "001212",
         "中旗新材",
         "57.64",
         "1.84",
         "14.76",
         "390.5149",
         "0.69",
         "305.24",
         "10.33",
         "19.19",
         "111.0",
         "97.0282",
         "20230911",
         "20230425",
         "20230303"
        ],
        [
         "14",
         "15",
         "123251",
         "华医转债",
         "167.825",
         "2.38",
         "301235",
         "华康洁净",
         "34.2",
         "3.01",
         "22.43",
         "152.4744",
         "10.07",
         "87.06",
         "15.7",
         "29.16",
         "115.0",
         "89.7195",
         "20250627",
         "20250109",
         "20241223"
        ],
        [
         "15",
         "16",
         "123076",
         "强力转债",
         "142.246",
         "2.26",
         "300429",
         "强力新材",
         "15.68",
         "7.54",
         "12.7",
         "123.4646",
         "15.21",
         "26.76",
         "8.89",
         "16.51",
         "113.0",
         "112.2191",
         "20210525",
         "20201204",
         "20201119"
        ],
        [
         "16",
         "17",
         "127086",
         "恒邦转债",
         "148.76",
         "2.26",
         "002237",
         "恒邦股份",
         "15.7",
         "3.15",
         "11.19",
         "140.3038",
         "6.03",
         "43.45",
         "7.83",
         "14.55",
         "108.0",
         "103.7037",
         "20231218",
         "20230707",
         "20230612"
        ],
        [
         "17",
         "18",
         "118033",
         "华特转债",
         "130.303",
         "2.16",
         "688268",
         "华特气体",
         "77.18",
         "12.52",
         "82.72",
         "93.3027",
         "39.66",
         "20.73",
         "57.9",
         "107.54",
         "115.0",
         "107.9303",
         "20230927",
         "20230414",
         "20230321"
        ],
        [
         "18",
         "19",
         "118053",
         "正帆转债",
         "150.347",
         "2.11",
         "688596",
         "正帆科技",
         "48.74",
         "7.86",
         "38.52",
         "126.5317",
         "18.82",
         "48.51",
         "26.96",
         "50.08",
         "112.0",
         "101.2377",
         "20250924",
         "20250403",
         "20250318"
        ],
        [
         "19",
         "20",
         "113639",
         "华正转债",
         "139.729",
         "2.01",
         "603186",
         "华正新材",
         "42.74",
         "5.43",
         "38.51",
         "110.9842",
         "25.9",
         "31.21",
         "26.96",
         "50.06",
         "108.0",
         "106.491",
         "20220728",
         "20220222",
         "20220124"
        ],
        [
         "20",
         "21",
         "123245",
         "集智转债",
         "244.1",
         "1.92",
         "300553",
         "集智股份",
         "40.6",
         "1.0",
         "18.11",
         "224.1855",
         "8.88",
         "192.23",
         "12.68",
         "23.54",
         "115.0",
         "83.5295",
         "20250220",
         "20240828",
         "20240814"
        ],
        [
         "21",
         "22",
         "128095",
         "恩捷转债",
         "142.9",
         "1.89",
         "002812",
         "恩捷股份",
         "45.85",
         "2.37",
         "32.01",
         "143.2365",
         "-0.23",
         "40.99",
         "22.41",
         "41.61",
         "110.0",
         "101.3573",
         "20200817",
         "20200228",
         "20200211"
        ],
        [
         "22",
         "23",
         "111005",
         "富春转债",
         "153.937",
         "1.71",
         "605189",
         "富春染织",
         "17.08",
         "4.59",
         "11.98",
         "142.571",
         "7.97",
         "48.48",
         "8.39",
         "15.57",
         "108.3",
         "103.6721",
         "20221229",
         "20220725",
         "20220623"
        ],
        [
         "23",
         "24",
         "113615",
         "金诚转债",
         "671.326",
         "1.69",
         "603979",
         "金诚信",
         "68.23",
         "0.22",
         "11.78",
         "579.202",
         "15.91",
         "502.92",
         "8.25",
         "15.31",
         "112.0",
         "111.3449",
         "20210629",
         "20210114",
         "20201223"
        ],
        [
         "24",
         "25",
         "118038",
         "金宏转债",
         "137.897",
         "1.54",
         "688106",
         "金宏气体",
         "21.73",
         "4.37",
         "18.97",
         "114.5493",
         "20.38",
         "29.43",
         "13.28",
         "24.66",
         "115.0",
         "106.5401",
         "20240122",
         "20230810",
         "20230717"
        ],
        [
         "25",
         "26",
         "111004",
         "明新转债",
         "133.816",
         "1.47",
         "605068",
         "明新旭腾",
         "25.97",
         "4.13",
         "24.41",
         "106.3908",
         "25.78",
         "19.95",
         "17.09",
         "31.73",
         "115.0",
         "111.5585",
         "20221010",
         "20220425",
         "20220330"
        ],
        [
         "26",
         "27",
         "127039",
         "北港转债",
         "138.808",
         "1.42",
         "000582",
         "北部湾港",
         "8.78",
         "1.86",
         "7.39",
         "118.8092",
         "16.83",
         "30.26",
         "5.17",
         "9.61",
         "108.0",
         "106.561",
         "20220105",
         "20210723",
         "20210629"
        ],
        [
         "27",
         "28",
         "118048",
         "利扬转债",
         "222.003",
         "1.4",
         "688135",
         "利扬芯片",
         "32.53",
         "1.56",
         "16.12",
         "201.799",
         "10.01",
         "139.69",
         "11.28",
         "20.96",
         "115.0",
         "92.6208",
         "20250108",
         "20240719",
         "20240702"
        ],
        [
         "28",
         "29",
         "118057",
         "甬矽转债",
         "174.237",
         "1.35",
         "688362",
         "甬矽电子",
         "36.16",
         "2.32",
         "28.36",
         "127.5035",
         "36.65",
         "108.07",
         "19.85",
         "36.87",
         "113.0",
         "83.7397",
         "20260102",
         "20250716",
         "20250626"
        ],
        [
         "29",
         "30",
         "113601",
         "塞力转债",
         "255.733",
         "1.27",
         "603716",
         "塞力医疗",
         "24.89",
         "0.57",
         "12.0",
         "207.4167",
         "23.29",
         "125.8",
         "8.4",
         "15.6",
         "115.0",
         "113.2562",
         "20210301",
         "20200915",
         "20200821"
        ],
        [
         "30",
         "31",
         "118040",
         "宏微转债",
         "130.986",
         "1.25",
         "688711",
         "宏微科技",
         "28.13",
         "8.82",
         "28.51",
         "98.6671",
         "32.76",
         "44.02",
         "19.96",
         "37.06",
         "115.0",
         "90.9482",
         "20240131",
         "20230814",
         "20230725"
        ],
        [
         "31",
         "32",
         "113042",
         "上银转债",
         "125.725",
         "1.24",
         "601229",
         "上海银行",
         "9.45",
         "2.83",
         "8.87",
         "106.5389",
         "18.01",
         "11.2",
         "-",
         "11.53",
         "112.0",
         "113.0578",
         "20210729",
         "20210210",
         "20210125"
        ],
        [
         "32",
         "33",
         "113046",
         "金田转债",
         "142.645",
         "1.19",
         "601609",
         "金田股份",
         "13.1",
         "3.89",
         "10.32",
         "126.938",
         "12.37",
         "30.96",
         "7.22",
         "13.42",
         "110.0",
         "108.9225",
         "20210927",
         "20210412",
         "20210322"
        ],
        [
         "33",
         "34",
         "127064",
         "杭氧转债",
         "141.0",
         "1.16",
         "002430",
         "杭氧股份",
         "27.31",
         "1.04",
         "26.07",
         "104.7564",
         "34.6",
         "33.33",
         "18.25",
         "33.89",
         "108.0",
         "105.7534",
         "20221125",
         "20220705",
         "20220519"
        ],
        [
         "34",
         "35",
         "113655",
         "欧22转债",
         "129.792",
         "1.14",
         "603833",
         "欧派家居",
         "53.15",
         "-0.88",
         "54.0",
         "98.4259",
         "31.87",
         "19.42",
         "37.8",
         "70.2",
         "112.0",
         "108.6882",
         "20230213",
         "20220901",
         "20220805"
        ],
        [
         "35",
         "36",
         "118021",
         "新致转债",
         "250.098",
         "1.08",
         "688590",
         "新致软件",
         "22.13",
         "-0.76",
         "10.56",
         "209.5644",
         "19.34",
         "167.16",
         "7.39",
         "13.73",
         "112.0",
         "93.6129",
         "20230410",
         "20221102",
         "20220927"
        ],
        [
         "36",
         "37",
         "113621",
         "彤程转债",
         "160.713",
         "1.08",
         "603650",
         "彤程新材",
         "47.93",
         "8.15",
         "31.11",
         "154.0662",
         "4.31",
         "47.21",
         "21.78",
         "40.44",
         "110.0",
         "109.1752",
         "20210802",
         "20210222",
         "20210126"
        ],
        [
         "37",
         "38",
         "113628",
         "晨丰转债",
         "138.75",
         "1.04",
         "603685",
         "晨丰科技",
         "17.9",
         "1.7",
         "12.77",
         "140.1723",
         "-1.01",
         "34.19",
         "8.94",
         "16.6",
         "115.0",
         "103.4013",
         "20220228",
         "20210917",
         "20210823"
        ],
        [
         "38",
         "39",
         "123255",
         "鼎龙转债",
         "175.718",
         "0.99",
         "300054",
         "鼎龙股份",
         "38.54",
         "5.53",
         "28.58",
         "134.8495",
         "30.31",
         "75.75",
         "20.01",
         "37.15",
         "110.0",
         "99.9833",
         "20251009",
         "20250423",
         "20250402"
        ],
        [
         "39",
         "40",
         "123254",
         "亿纬转债",
         "174.0",
         "0.99",
         "300014",
         "亿纬锂能",
         "83.37",
         "3.72",
         "50.65",
         "164.6002",
         "5.71",
         "68.79",
         "35.46",
         "65.85",
         "112.0",
         "103.0893",
         "20250929",
         "20250411",
         "20250324"
        ],
        [
         "40",
         "41",
         "123224",
         "宇邦转债",
         "132.2",
         "0.98",
         "301266",
         "宇邦新材",
         "35.82",
         "4.25",
         "36.84",
         "97.2313",
         "35.96",
         "35.92",
         "25.79",
         "47.89",
         "115.0",
         "97.2653",
         "20240325",
         "20231018",
         "20230919"
        ],
        [
         "41",
         "42",
         "113673",
         "岱美转债",
         "128.255",
         "0.97",
         "603730",
         "岱美股份",
         "6.83",
         "2.86",
         "7.37",
         "92.673",
         "38.4",
         "19.94",
         "5.16",
         "9.58",
         "112.0",
         "106.9301",
         "20240124",
         "20230810",
         "20230718"
        ],
        [
         "42",
         "43",
         "113631",
         "皖天转债",
         "137.29",
         "0.95",
         "603689",
         "皖天然气",
         "8.75",
         "0.81",
         "6.86",
         "127.551",
         "7.64",
         "26.05",
         "4.8",
         "8.92",
         "110.0",
         "108.9133",
         "20220512",
         "20211210",
         "20211108"
        ],
        [
         "43",
         "44",
         "110063",
         "鹰19转债",
         "115.766",
         "0.83",
         "600567",
         "山鹰国际",
         "1.83",
         "-1.08",
         "1.76",
         "103.9773",
         "11.34",
         "4.58",
         "1.23",
         "2.29",
         "111.0",
         "110.693",
         "20200619",
         "20200103",
         "20191213"
        ],
        [
         "44",
         "45",
         "128119",
         "龙大转债",
         "120.986",
         "0.8",
         "002726",
         "龙大美食",
         "4.88",
         "-1.61",
         "9.3",
         "52.4731",
         "130.57",
         "8.77",
         "6.51",
         "12.09",
         "115.0",
         "111.2315",
         "20210118",
         "20200807",
         "20200713"
        ],
        [
         "45",
         "46",
         "127073",
         "天赐转债",
         "141.3",
         "0.73",
         "002709",
         "天赐材料",
         "37.29",
         "5.58",
         "28.5",
         "130.8421",
         "7.99",
         "32.92",
         "19.95",
         "37.05",
         "109.0",
         "106.3055",
         "20230329",
         "20221027",
         "20220923"
        ],
        [
         "46",
         "47",
         "111010",
         "立昂转债",
         "129.186",
         "0.73",
         "605358",
         "立昂微",
         "33.76",
         "5.04",
         "33.59",
         "100.5061",
         "28.54",
         "18.6",
         "23.51",
         "43.67",
         "112.0",
         "108.923",
         "20230518",
         "20221207",
         "20221114"
        ],
        [
         "47",
         "48",
         "113062",
         "常银转债",
         "130.148",
         "0.72",
         "601128",
         "常熟银行",
         "6.9",
         "0.58",
         "5.89",
         "117.1477",
         "11.1",
         "25.73",
         "-",
         "7.66",
         "107.0",
         "103.5121",
         "20230321",
         "20221017",
         "20220915"
        ],
        [
         "48",
         "49",
         "113627",
         "太平转债",
         "116.791",
         "0.69",
         "603877",
         "太平鸟",
         "14.21",
         "0.35",
         "20.88",
         "68.0556",
         "71.61",
         "8.09",
         "14.62",
         "27.14",
         "110.0",
         "108.0499",
         "20220121",
         "20210806",
         "20210715"
        ],
        [
         "49",
         "50",
         "110077",
         "洪城转债",
         "203.449",
         "0.61",
         "600461",
         "洪城环境",
         "8.98",
         "-0.11",
         "4.88",
         "184.0164",
         "10.56",
         "86.04",
         "3.42",
         "6.34",
         "110.0",
         "109.3582",
         "20210526",
         "20201217",
         "20201120"
        ]
       ],
       "shape": {
        "columns": 20,
        "rows": 422
       }
      },
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>序号</th>\n",
       "      <th>转债代码</th>\n",
       "      <th>转债名称</th>\n",
       "      <th>转债最新价</th>\n",
       "      <th>转债涨跌幅</th>\n",
       "      <th>正股代码</th>\n",
       "      <th>正股名称</th>\n",
       "      <th>正股最新价</th>\n",
       "      <th>正股涨跌幅</th>\n",
       "      <th>转股价</th>\n",
       "      <th>转股价值</th>\n",
       "      <th>转股溢价率</th>\n",
       "      <th>纯债溢价率</th>\n",
       "      <th>回售触发价</th>\n",
       "      <th>强赎触发价</th>\n",
       "      <th>到期赎回价</th>\n",
       "      <th>纯债价值</th>\n",
       "      <th>开始转股日</th>\n",
       "      <th>上市日期</th>\n",
       "      <th>申购日期</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>123118</td>\n",
       "      <td>惠城转债</td>\n",
       "      <td>1605.6</td>\n",
       "      <td>20.00</td>\n",
       "      <td>300779</td>\n",
       "      <td>惠城环保</td>\n",
       "      <td>170.88</td>\n",
       "      <td>20.00</td>\n",
       "      <td>11.11</td>\n",
       "      <td>1538.0739</td>\n",
       "      <td>4.39</td>\n",
       "      <td>1380.76</td>\n",
       "      <td>7.78</td>\n",
       "      <td>14.44</td>\n",
       "      <td>115.0</td>\n",
       "      <td>108.4306</td>\n",
       "      <td>20220113</td>\n",
       "      <td>20210726</td>\n",
       "      <td>20210707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>118056</td>\n",
       "      <td>路维转债</td>\n",
       "      <td>214.921</td>\n",
       "      <td>12.69</td>\n",
       "      <td>688401</td>\n",
       "      <td>路维光电</td>\n",
       "      <td>58.32</td>\n",
       "      <td>20.00</td>\n",
       "      <td>32.70</td>\n",
       "      <td>178.3486</td>\n",
       "      <td>20.51</td>\n",
       "      <td>128.83</td>\n",
       "      <td>22.89</td>\n",
       "      <td>42.51</td>\n",
       "      <td>112.0</td>\n",
       "      <td>93.9199</td>\n",
       "      <td>20251217</td>\n",
       "      <td>20250710</td>\n",
       "      <td>20250611</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>110096</td>\n",
       "      <td>豫光转债</td>\n",
       "      <td>260.129</td>\n",
       "      <td>11.95</td>\n",
       "      <td>600531</td>\n",
       "      <td>豫光金铅</td>\n",
       "      <td>14.58</td>\n",
       "      <td>10.04</td>\n",
       "      <td>5.95</td>\n",
       "      <td>245.0420</td>\n",
       "      <td>6.16</td>\n",
       "      <td>153.12</td>\n",
       "      <td>4.17</td>\n",
       "      <td>7.74</td>\n",
       "      <td>112.0</td>\n",
       "      <td>102.7695</td>\n",
       "      <td>20250217</td>\n",
       "      <td>20240903</td>\n",
       "      <td>20240812</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>128144</td>\n",
       "      <td>利民转债</td>\n",
       "      <td>265.834</td>\n",
       "      <td>6.94</td>\n",
       "      <td>002734</td>\n",
       "      <td>利民股份</td>\n",
       "      <td>20.80</td>\n",
       "      <td>7.77</td>\n",
       "      <td>8.10</td>\n",
       "      <td>256.7901</td>\n",
       "      <td>3.52</td>\n",
       "      <td>144.65</td>\n",
       "      <td>5.67</td>\n",
       "      <td>10.53</td>\n",
       "      <td>110.0</td>\n",
       "      <td>108.6596</td>\n",
       "      <td>20210906</td>\n",
       "      <td>20210324</td>\n",
       "      <td>20210301</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>123235</td>\n",
       "      <td>亿田转债</td>\n",
       "      <td>256.554</td>\n",
       "      <td>6.11</td>\n",
       "      <td>300911</td>\n",
       "      <td>亿田智能</td>\n",
       "      <td>54.20</td>\n",
       "      <td>8.57</td>\n",
       "      <td>21.31</td>\n",
       "      <td>254.3407</td>\n",
       "      <td>0.87</td>\n",
       "      <td>143.15</td>\n",
       "      <td>14.92</td>\n",
       "      <td>27.70</td>\n",
       "      <td>115.0</td>\n",
       "      <td>105.5119</td>\n",
       "      <td>20240627</td>\n",
       "      <td>20240112</td>\n",
       "      <td>20231221</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>417</th>\n",
       "      <td>418</td>\n",
       "      <td>127107</td>\n",
       "      <td>领益转债</td>\n",
       "      <td>-</td>\n",
       "      <td>NaN</td>\n",
       "      <td>002600</td>\n",
       "      <td>领益智造</td>\n",
       "      <td>15.30</td>\n",
       "      <td>-4.61</td>\n",
       "      <td>9.13</td>\n",
       "      <td>167.5794</td>\n",
       "      <td>11.29</td>\n",
       "      <td>86.18</td>\n",
       "      <td>6.39</td>\n",
       "      <td>11.87</td>\n",
       "      <td>108.0</td>\n",
       "      <td>100.1722</td>\n",
       "      <td>20250522</td>\n",
       "      <td>20241206</td>\n",
       "      <td>20241118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>418</th>\n",
       "      <td>419</td>\n",
       "      <td>127033</td>\n",
       "      <td>中装转2</td>\n",
       "      <td>-</td>\n",
       "      <td>NaN</td>\n",
       "      <td>002822</td>\n",
       "      <td>*ST中装</td>\n",
       "      <td>3.72</td>\n",
       "      <td>2.76</td>\n",
       "      <td>3.79</td>\n",
       "      <td>98.1530</td>\n",
       "      <td>-8.59</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2.65</td>\n",
       "      <td>4.93</td>\n",
       "      <td>112.0</td>\n",
       "      <td>-</td>\n",
       "      <td>20211022</td>\n",
       "      <td>20210524</td>\n",
       "      <td>20210416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419</th>\n",
       "      <td>420</td>\n",
       "      <td>123089</td>\n",
       "      <td>九洲转2</td>\n",
       "      <td>-</td>\n",
       "      <td>NaN</td>\n",
       "      <td>300040</td>\n",
       "      <td>九洲集团</td>\n",
       "      <td>6.75</td>\n",
       "      <td>-0.44</td>\n",
       "      <td>5.44</td>\n",
       "      <td>124.0809</td>\n",
       "      <td>-0.23</td>\n",
       "      <td>21.34</td>\n",
       "      <td>3.81</td>\n",
       "      <td>7.07</td>\n",
       "      <td>115.0</td>\n",
       "      <td>102.0293</td>\n",
       "      <td>20210625</td>\n",
       "      <td>20210108</td>\n",
       "      <td>20201221</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>420</th>\n",
       "      <td>421</td>\n",
       "      <td>123056</td>\n",
       "      <td>雪榕转债</td>\n",
       "      <td>-</td>\n",
       "      <td>NaN</td>\n",
       "      <td>300511</td>\n",
       "      <td>雪榕生物</td>\n",
       "      <td>6.72</td>\n",
       "      <td>3.54</td>\n",
       "      <td>4.10</td>\n",
       "      <td>163.9024</td>\n",
       "      <td>-7.26</td>\n",
       "      <td>50.65</td>\n",
       "      <td>2.87</td>\n",
       "      <td>4.92</td>\n",
       "      <td>115.0</td>\n",
       "      <td>100.8945</td>\n",
       "      <td>20210104</td>\n",
       "      <td>20200724</td>\n",
       "      <td>20200624</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421</th>\n",
       "      <td>422</td>\n",
       "      <td>128076</td>\n",
       "      <td>金轮转债</td>\n",
       "      <td>-</td>\n",
       "      <td>NaN</td>\n",
       "      <td>002722</td>\n",
       "      <td>物产金轮</td>\n",
       "      <td>15.53</td>\n",
       "      <td>-1.21</td>\n",
       "      <td>13.34</td>\n",
       "      <td>116.4168</td>\n",
       "      <td>0.88</td>\n",
       "      <td>6.77</td>\n",
       "      <td>9.34</td>\n",
       "      <td>17.34</td>\n",
       "      <td>110.0</td>\n",
       "      <td>109.9942</td>\n",
       "      <td>20200420</td>\n",
       "      <td>20191108</td>\n",
       "      <td>20191014</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>422 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      序号    转债代码  转债名称    转债最新价  转债涨跌幅    正股代码   正股名称   正股最新价  正股涨跌幅    转股价  \\\n",
       "0      1  123118  惠城转债   1605.6  20.00  300779   惠城环保  170.88  20.00  11.11   \n",
       "1      2  118056  路维转债  214.921  12.69  688401   路维光电   58.32  20.00  32.70   \n",
       "2      3  110096  豫光转债  260.129  11.95  600531   豫光金铅   14.58  10.04   5.95   \n",
       "3      4  128144  利民转债  265.834   6.94  002734   利民股份   20.80   7.77   8.10   \n",
       "4      5  123235  亿田转债  256.554   6.11  300911   亿田智能   54.20   8.57  21.31   \n",
       "..   ...     ...   ...      ...    ...     ...    ...     ...    ...    ...   \n",
       "417  418  127107  领益转债        -    NaN  002600   领益智造   15.30  -4.61   9.13   \n",
       "418  419  127033  中装转2        -    NaN  002822  *ST中装    3.72   2.76   3.79   \n",
       "419  420  123089  九洲转2        -    NaN  300040   九洲集团    6.75  -0.44   5.44   \n",
       "420  421  123056  雪榕转债        -    NaN  300511   雪榕生物    6.72   3.54   4.10   \n",
       "421  422  128076  金轮转债        -    NaN  002722   物产金轮   15.53  -1.21  13.34   \n",
       "\n",
       "          转股价值  转股溢价率    纯债溢价率  回售触发价  强赎触发价  到期赎回价      纯债价值     开始转股日  \\\n",
       "0    1538.0739   4.39  1380.76   7.78  14.44  115.0  108.4306  20220113   \n",
       "1     178.3486  20.51   128.83  22.89  42.51  112.0   93.9199  20251217   \n",
       "2     245.0420   6.16   153.12   4.17   7.74  112.0  102.7695  20250217   \n",
       "3     256.7901   3.52   144.65   5.67  10.53  110.0  108.6596  20210906   \n",
       "4     254.3407   0.87   143.15  14.92  27.70  115.0  105.5119  20240627   \n",
       "..         ...    ...      ...    ...    ...    ...       ...       ...   \n",
       "417   167.5794  11.29    86.18   6.39  11.87  108.0  100.1722  20250522   \n",
       "418    98.1530  -8.59     0.00   2.65   4.93  112.0         -  20211022   \n",
       "419   124.0809  -0.23    21.34   3.81   7.07  115.0  102.0293  20210625   \n",
       "420   163.9024  -7.26    50.65   2.87   4.92  115.0  100.8945  20210104   \n",
       "421   116.4168   0.88     6.77   9.34  17.34  110.0  109.9942  20200420   \n",
       "\n",
       "         上市日期      申购日期  \n",
       "0    20210726  20210707  \n",
       "1    20250710  20250611  \n",
       "2    20240903  20240812  \n",
       "3    20210324  20210301  \n",
       "4    20240112  20231221  \n",
       "..        ...       ...  \n",
       "417  20241206  20241118  \n",
       "418  20210524  20210416  \n",
       "419  20210108  20201221  \n",
       "420  20200724  20200624  \n",
       "421  20191108  20191014  \n",
       "\n",
       "[422 rows x 20 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bond_cov_comparison_df = ak.bond_cov_comparison()\n",
    "bond_cov_comparison_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b3af01fb",
   "metadata": {},
   "outputs": [
    {
     "ename": "TypeError",
     "evalue": "'NoneType' object is not subscriptable",
     "output_type": "error",
     "traceback": [
      "\u001b[31m---------------------------------------------------------------------------\u001b[39m",
      "\u001b[31mTypeError\u001b[39m                                 Traceback (most recent call last)",
      "\u001b[36mCell\u001b[39m\u001b[36m \u001b[39m\u001b[32mIn[17]\u001b[39m\u001b[32m, line 1\u001b[39m\n\u001b[32m----> \u001b[39m\u001b[32m1\u001b[39m bond_zh_cov_value_analysis_df = \u001b[43mak\u001b[49m\u001b[43m.\u001b[49m\u001b[43mbond_zh_cov_value_analysis\u001b[49m\u001b[43m(\u001b[49m\u001b[43msymbol\u001b[49m\u001b[43m=\u001b[49m\u001b[33;43m\"\u001b[39;49m\u001b[33;43msz148099\u001b[39;49m\u001b[33;43m\"\u001b[39;49m\u001b[43m)\u001b[49m\n\u001b[32m      2\u001b[39m bond_zh_cov_value_analysis_df\n",
      "\u001b[36mFile \u001b[39m\u001b[32m~/.conda/envs/fas/lib/python3.12/site-packages/akshare/bond/bond_zh_cov.py:650\u001b[39m, in \u001b[36mbond_zh_cov_value_analysis\u001b[39m\u001b[34m(symbol)\u001b[39m\n\u001b[32m    648\u001b[39m r = requests.get(url, params=params)\n\u001b[32m    649\u001b[39m data_json = r.json()\n\u001b[32m--> \u001b[39m\u001b[32m650\u001b[39m temp_df = pd.DataFrame(\u001b[43mdata_json\u001b[49m\u001b[43m[\u001b[49m\u001b[33;43m\"\u001b[39;49m\u001b[33;43mresult\u001b[39;49m\u001b[33;43m\"\u001b[39;49m\u001b[43m]\u001b[49m\u001b[43m[\u001b[49m\u001b[33;43m\"\u001b[39;49m\u001b[33;43mdata\u001b[39;49m\u001b[33;43m\"\u001b[39;49m\u001b[43m]\u001b[49m)\n\u001b[32m    651\u001b[39m temp_df.columns = [\n\u001b[32m    652\u001b[39m     \u001b[33m\"\u001b[39m\u001b[33m日期\u001b[39m\u001b[33m\"\u001b[39m,\n\u001b[32m    653\u001b[39m     \u001b[33m\"\u001b[39m\u001b[33m-\u001b[39m\u001b[33m\"\u001b[39m,\n\u001b[32m   (...)\u001b[39m\u001b[32m    664\u001b[39m     \u001b[33m\"\u001b[39m\u001b[33m-\u001b[39m\u001b[33m\"\u001b[39m,\n\u001b[32m    665\u001b[39m ]\n\u001b[32m    666\u001b[39m temp_df = temp_df[\n\u001b[32m    667\u001b[39m     [\n\u001b[32m    668\u001b[39m         \u001b[33m\"\u001b[39m\u001b[33m日期\u001b[39m\u001b[33m\"\u001b[39m,\n\u001b[32m   (...)\u001b[39m\u001b[32m    674\u001b[39m     ]\n\u001b[32m    675\u001b[39m ]\n",
      "\u001b[31mTypeError\u001b[39m: 'NoneType' object is not subscriptable"
     ]
    }
   ],
   "source": [
    "bond_zh_cov_value_analysis_df = ak.bond_zh_cov_value_analysis(symbol=\"sz148099\")\n",
    "bond_zh_cov_value_analysis_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "6a468fa6",
   "metadata": {},
   "outputs": [
    {
     "ename": "TypeError",
     "evalue": "'NoneType' object is not subscriptable",
     "output_type": "error",
     "traceback": [
      "\u001b[31m---------------------------------------------------------------------------\u001b[39m",
      "\u001b[31mTypeError\u001b[39m                                 Traceback (most recent call last)",
      "\u001b[36mCell\u001b[39m\u001b[36m \u001b[39m\u001b[32mIn[19]\u001b[39m\u001b[32m, line 1\u001b[39m\n\u001b[32m----> \u001b[39m\u001b[32m1\u001b[39m bond_zh_cov_value_analysis_df = \u001b[43mak\u001b[49m\u001b[43m.\u001b[49m\u001b[43mbond_zh_cov_value_analysis\u001b[49m\u001b[43m(\u001b[49m\u001b[43msymbol\u001b[49m\u001b[43m=\u001b[49m\u001b[33;43m\"\u001b[39;49m\u001b[33;43m148099\u001b[39;49m\u001b[33;43m\"\u001b[39;49m\u001b[43m)\u001b[49m\n\u001b[32m      2\u001b[39m bond_zh_cov_value_analysis_df\n",
      "\u001b[36mFile \u001b[39m\u001b[32m~/.conda/envs/fas/lib/python3.12/site-packages/akshare/bond/bond_zh_cov.py:650\u001b[39m, in \u001b[36mbond_zh_cov_value_analysis\u001b[39m\u001b[34m(symbol)\u001b[39m\n\u001b[32m    648\u001b[39m r = requests.get(url, params=params)\n\u001b[32m    649\u001b[39m data_json = r.json()\n\u001b[32m--> \u001b[39m\u001b[32m650\u001b[39m temp_df = pd.DataFrame(\u001b[43mdata_json\u001b[49m\u001b[43m[\u001b[49m\u001b[33;43m\"\u001b[39;49m\u001b[33;43mresult\u001b[39;49m\u001b[33;43m\"\u001b[39;49m\u001b[43m]\u001b[49m\u001b[43m[\u001b[49m\u001b[33;43m\"\u001b[39;49m\u001b[33;43mdata\u001b[39;49m\u001b[33;43m\"\u001b[39;49m\u001b[43m]\u001b[49m)\n\u001b[32m    651\u001b[39m temp_df.columns = [\n\u001b[32m    652\u001b[39m     \u001b[33m\"\u001b[39m\u001b[33m日期\u001b[39m\u001b[33m\"\u001b[39m,\n\u001b[32m    653\u001b[39m     \u001b[33m\"\u001b[39m\u001b[33m-\u001b[39m\u001b[33m\"\u001b[39m,\n\u001b[32m   (...)\u001b[39m\u001b[32m    664\u001b[39m     \u001b[33m\"\u001b[39m\u001b[33m-\u001b[39m\u001b[33m\"\u001b[39m,\n\u001b[32m    665\u001b[39m ]\n\u001b[32m    666\u001b[39m temp_df = temp_df[\n\u001b[32m    667\u001b[39m     [\n\u001b[32m    668\u001b[39m         \u001b[33m\"\u001b[39m\u001b[33m日期\u001b[39m\u001b[33m\"\u001b[39m,\n\u001b[32m   (...)\u001b[39m\u001b[32m    674\u001b[39m     ]\n\u001b[32m    675\u001b[39m ]\n",
      "\u001b[31mTypeError\u001b[39m: 'NoneType' object is not subscriptable"
     ]
    }
   ],
   "source": [
    "bond_zh_cov_value_analysis_df = ak.bond_zh_cov_value_analysis(symbol=\"148099\")\n",
    "bond_zh_cov_value_analysis_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "f891c099",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.microsoft.datawrangler.viewer.v0+json": {
       "columns": [
        {
         "name": "index",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "曲线名称",
         "rawType": "object",
         "type": "string"
        },
        {
         "name": "日期",
         "rawType": "object",
         "type": "unknown"
        },
        {
         "name": "3月",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "6月",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "1年",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "3年",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "5年",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "7年",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "10年",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "30年",
         "rawType": "float64",
         "type": "float"
        }
       ],
       "ref": "c8ec0203-bc86-46a2-9adb-202a196237ad",
       "rows": [
        [
         "0",
         "中债中短期票据收益率曲线(AAA)",
         "2024-02-01",
         "2.4291",
         "2.4349",
         "2.4409",
         "2.5881",
         "2.7571",
         "2.7725",
         "2.8",
         null
        ],
        [
         "1",
         "中债商业银行普通债收益率曲线(AAA)",
         "2024-02-01",
         "2.3186",
         "2.3284",
         "2.3762",
         "2.5096",
         "2.6316",
         "2.6515",
         "2.69",
         "2.9507"
        ],
        [
         "2",
         "中债国债收益率曲线",
         "2024-02-01",
         "1.7753",
         "1.8572",
         "1.8802",
         "2.2107",
         "2.3048",
         "2.4215",
         "2.4354",
         "2.6472"
        ],
        [
         "3",
         "中债国债收益率曲线",
         "2024-02-02",
         "1.7718",
         "1.8782",
         "1.8903",
         "2.1886",
         "2.2799",
         "2.4115",
         "2.4244",
         "2.6353"
        ],
        [
         "4",
         "中债中短期票据收益率曲线(AAA)",
         "2024-02-02",
         "2.4123",
         "2.425",
         "2.4422",
         "2.5868",
         "2.7527",
         "2.768",
         "2.7951",
         null
        ],
        [
         "5",
         "中债商业银行普通债收益率曲线(AAA)",
         "2024-02-02",
         "2.3176",
         "2.3263",
         "2.3874",
         "2.5131",
         "2.6301",
         "2.647",
         "2.6851",
         "2.9507"
        ],
        [
         "6",
         "中债国债收益率曲线",
         "2024-02-04",
         "1.7718",
         "1.8738",
         "1.8803",
         "2.1743",
         "2.2728",
         "2.3961",
         "2.4053",
         "2.6076"
        ],
        [
         "7",
         "中债中短期票据收益率曲线(AAA)",
         "2024-02-04",
         "2.397",
         "2.4056",
         "2.4246",
         "2.5717",
         "2.7483",
         "2.7636",
         "2.7749",
         null
        ],
        [
         "8",
         "中债商业银行普通债收益率曲线(AAA)",
         "2024-02-04",
         "2.3026",
         "2.3013",
         "2.3637",
         "2.5002",
         "2.6245",
         "2.6426",
         "2.665",
         "2.9257"
        ],
        [
         "9",
         "中债国债收益率曲线",
         "2024-02-05",
         "1.7505",
         "1.8445",
         "1.8829",
         "2.1887",
         "2.2751",
         "2.3978",
         "2.4002",
         "2.5974"
        ],
        [
         "10",
         "中债中短期票据收益率曲线(AAA)",
         "2024-02-05",
         "2.39",
         "2.39",
         "2.4145",
         "2.5611",
         "2.7294",
         "2.7448",
         "2.765",
         null
        ],
        [
         "11",
         "中债商业银行普通债收益率曲线(AAA)",
         "2024-02-05",
         "2.3035",
         "2.3152",
         "2.3611",
         "2.5007",
         "2.6167",
         "2.6238",
         "2.655",
         "2.9057"
        ],
        [
         "12",
         "中债中短期票据收益率曲线(AAA)",
         "2024-02-06",
         "2.4",
         "2.4",
         "2.422",
         "2.5785",
         "2.7378",
         "2.7428",
         "2.7905",
         null
        ],
        [
         "13",
         "中债商业银行普通债收益率曲线(AAA)",
         "2024-02-06",
         "2.2985",
         "2.334",
         "2.3733",
         "2.5181",
         "2.6205",
         "2.6318",
         "2.68",
         "2.8857"
        ],
        [
         "14",
         "中债国债收益率曲线",
         "2024-02-06",
         "1.7558",
         "1.8518",
         "1.9269",
         "2.2405",
         "2.3329",
         "2.4503",
         "2.4525",
         "2.6579"
        ],
        [
         "15",
         "中债中短期票据收益率曲线(AAA)",
         "2024-02-07",
         "2.4",
         "2.4",
         "2.4167",
         "2.5767",
         "2.7377",
         "2.7465",
         "2.7817",
         null
        ],
        [
         "16",
         "中债商业银行普通债收益率曲线(AAA)",
         "2024-02-07",
         "2.2885",
         "2.3246",
         "2.3612",
         "2.5085",
         "2.6215",
         "2.6355",
         "2.6713",
         "2.8857"
        ],
        [
         "17",
         "中债国债收益率曲线",
         "2024-02-07",
         "1.744",
         "1.8511",
         "1.9287",
         "2.1864",
         "2.2985",
         "2.415",
         "2.4153",
         "2.6214"
        ],
        [
         "18",
         "中债商业银行普通债收益率曲线(AAA)",
         "2024-02-08",
         "2.1985",
         "2.2634",
         "2.3418",
         "2.5086",
         "2.6209",
         "2.6338",
         "2.6696",
         "2.8857"
        ],
        [
         "19",
         "中债国债收益率曲线",
         "2024-02-08",
         "1.7277",
         "1.8541",
         "1.9265",
         "2.1891",
         "2.2885",
         "2.4353",
         "2.4379",
         "2.6505"
        ],
        [
         "20",
         "中债中短期票据收益率曲线(AAA)",
         "2024-02-08",
         "2.3716",
         "2.39",
         "2.4017",
         "2.5771",
         "2.7277",
         "2.7448",
         "2.78",
         null
        ],
        [
         "21",
         "中债中短期票据收益率曲线(AAA)",
         "2024-02-09",
         "2.3668",
         "2.3851",
         "2.3969",
         "2.5771",
         "2.7277",
         "2.7447",
         "2.7799",
         null
        ],
        [
         "22",
         "中债商业银行普通债收益率曲线(AAA)",
         "2024-02-09",
         "2.1835",
         "2.2646",
         "2.3468",
         "2.5085",
         "2.6208",
         "2.6338",
         "2.6695",
         "2.8857"
        ],
        [
         "23",
         "中债国债收益率曲线",
         "2024-02-09",
         "1.7127",
         "1.8481",
         "1.9265",
         "2.1891",
         "2.2885",
         "2.43",
         "2.4302",
         "2.6505"
        ],
        [
         "24",
         "中债国债收益率曲线",
         "2024-02-18",
         "1.687",
         "1.8593",
         "1.9292",
         "2.1884",
         "2.2972",
         "2.4356",
         "2.4393",
         "2.643"
        ],
        [
         "25",
         "中债中短期票据收益率曲线(AAA)",
         "2024-02-18",
         "2.3388",
         "2.37",
         "2.3916",
         "2.5787",
         "2.7362",
         "2.7487",
         "2.7799",
         null
        ],
        [
         "26",
         "中债商业银行普通债收益率曲线(AAA)",
         "2024-02-18",
         "2.1262",
         "2.2686",
         "2.3618",
         "2.5101",
         "2.6294",
         "2.6423",
         "2.6695",
         "2.8857"
        ],
        [
         "27",
         "中债国债收益率曲线",
         "2024-02-19",
         "1.6713",
         "1.8779",
         "1.9157",
         "2.1909",
         "2.3058",
         "2.4263",
         "2.4344",
         "2.627"
        ],
        [
         "28",
         "中债中短期票据收益率曲线(AAA)",
         "2024-02-19",
         "2.3099",
         "2.3413",
         "2.3784",
         "2.5697",
         "2.7396",
         "2.7549",
         "2.7912",
         null
        ],
        [
         "29",
         "中债商业银行普通债收益率曲线(AAA)",
         "2024-02-19",
         "2.1254",
         "2.2406",
         "2.3201",
         "2.4888",
         "2.6306",
         "2.6485",
         "2.6807",
         "2.8857"
        ],
        [
         "30",
         "中债中短期票据收益率曲线(AAA)",
         "2024-02-20",
         "2.2822",
         "2.3204",
         "2.3609",
         "2.5646",
         "2.7346",
         "2.7499",
         "2.7809",
         null
        ],
        [
         "31",
         "中债商业银行普通债收益率曲线(AAA)",
         "2024-02-20",
         "2.1284",
         "2.2295",
         "2.3107",
         "2.4667",
         "2.616",
         "2.6435",
         "2.6705",
         "2.8857"
        ],
        [
         "32",
         "中债国债收益率曲线",
         "2024-02-20",
         "1.6632",
         "1.7937",
         "1.8649",
         "2.1634",
         "2.2759",
         "2.4041",
         "2.4134",
         "2.6004"
        ],
        [
         "33",
         "中债中短期票据收益率曲线(AAA)",
         "2024-02-21",
         "2.2792",
         "2.3008",
         "2.3447",
         "2.5529",
         "2.7302",
         "2.7504",
         "2.7711",
         null
        ],
        [
         "34",
         "中债商业银行普通债收益率曲线(AAA)",
         "2024-02-21",
         "2.1294",
         "2.2104",
         "2.2914",
         "2.4659",
         "2.6116",
         "2.6398",
         "2.6606",
         "2.8857"
        ],
        [
         "35",
         "中债国债收益率曲线",
         "2024-02-21",
         "1.6017",
         "1.7497",
         "1.8149",
         "2.1634",
         "2.2683",
         "2.4018",
         "2.4119",
         "2.601"
        ],
        [
         "36",
         "中债中短期票据收益率曲线(AAA)",
         "2024-02-22",
         "2.2587",
         "2.2935",
         "2.3235",
         "2.5392",
         "2.73",
         "2.7425",
         "2.7701",
         null
        ],
        [
         "37",
         "中债商业银行普通债收益率曲线(AAA)",
         "2024-02-22",
         "2.1185",
         "2.2062",
         "2.2716",
         "2.4414",
         "2.5955",
         "2.632",
         "2.6597",
         "2.8757"
        ],
        [
         "38",
         "中债国债收益率曲线",
         "2024-02-22",
         "1.6052",
         "1.744",
         "1.7731",
         "2.1284",
         "2.2439",
         "2.3835",
         "2.4033",
         "2.591"
        ],
        [
         "39",
         "中债国债收益率曲线",
         "2024-02-23",
         "1.5512",
         "1.7215",
         "1.7699",
         "2.1234",
         "2.2495",
         "2.381",
         "2.4009",
         "2.5809"
        ],
        [
         "40",
         "中债中短期票据收益率曲线(AAA)",
         "2024-02-23",
         "2.2509",
         "2.2763",
         "2.3044",
         "2.5252",
         "2.6925",
         "2.7318",
         "2.7601",
         null
        ],
        [
         "41",
         "中债商业银行普通债收益率曲线(AAA)",
         "2024-02-23",
         "2.1185",
         "2.198",
         "2.2416",
         "2.4207",
         "2.5583",
         "2.612",
         "2.6397",
         "2.8757"
        ],
        [
         "42",
         "中债中短期票据收益率曲线(AAA)",
         "2024-02-26",
         "2.2408",
         "2.2682",
         "2.3",
         "2.5069",
         "2.6683",
         "2.7218",
         "2.75",
         null
        ],
        [
         "43",
         "中债商业银行普通债收益率曲线(AAA)",
         "2024-02-26",
         "2.1334",
         "2.1975",
         "2.2404",
         "2.4143",
         "2.5482",
         "2.6019",
         "2.6295",
         "2.8757"
        ],
        [
         "44",
         "中债国债收益率曲线",
         "2024-02-26",
         "1.5512",
         "1.7129",
         "1.767",
         "2.1134",
         "2.2244",
         "2.3629",
         "2.3789",
         "2.54"
        ],
        [
         "45",
         "中债中短期票据收益率曲线(AAA)",
         "2024-02-27",
         "2.237",
         "2.2545",
         "2.2876",
         "2.4944",
         "2.6475",
         "2.7068",
         "2.75",
         null
        ],
        [
         "46",
         "中债商业银行普通债收益率曲线(AAA)",
         "2024-02-27",
         "2.1338",
         "2.191",
         "2.2408",
         "2.3948",
         "2.5273",
         "2.587",
         "2.6195",
         "2.8557"
        ],
        [
         "47",
         "中债国债收益率曲线",
         "2024-02-27",
         "1.5855",
         "1.6785",
         "1.7739",
         "2.1334",
         "2.2419",
         "2.3675",
         "2.3809",
         "2.5224"
        ],
        [
         "48",
         "中债国债收益率曲线",
         "2024-02-28",
         "1.6625",
         "1.7031",
         "1.7863",
         "2.1103",
         "2.2223",
         "2.34",
         "2.3376",
         "2.4868"
        ],
        [
         "49",
         "中债商业银行普通债收益率曲线(AAA)",
         "2024-02-28",
         "2.1341",
         "2.1797",
         "2.2466",
         "2.3848",
         "2.4973",
         "2.5681",
         "2.6098",
         "2.8357"
        ]
       ],
       "shape": {
        "columns": 10,
        "rows": 744
       }
      },
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>曲线名称</th>\n",
       "      <th>日期</th>\n",
       "      <th>3月</th>\n",
       "      <th>6月</th>\n",
       "      <th>1年</th>\n",
       "      <th>3年</th>\n",
       "      <th>5年</th>\n",
       "      <th>7年</th>\n",
       "      <th>10年</th>\n",
       "      <th>30年</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>中债中短期票据收益率曲线(AAA)</td>\n",
       "      <td>2024-02-01</td>\n",
       "      <td>2.4291</td>\n",
       "      <td>2.4349</td>\n",
       "      <td>2.4409</td>\n",
       "      <td>2.5881</td>\n",
       "      <td>2.7571</td>\n",
       "      <td>2.7725</td>\n",
       "      <td>2.8000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>中债商业银行普通债收益率曲线(AAA)</td>\n",
       "      <td>2024-02-01</td>\n",
       "      <td>2.3186</td>\n",
       "      <td>2.3284</td>\n",
       "      <td>2.3762</td>\n",
       "      <td>2.5096</td>\n",
       "      <td>2.6316</td>\n",
       "      <td>2.6515</td>\n",
       "      <td>2.6900</td>\n",
       "      <td>2.9507</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>中债国债收益率曲线</td>\n",
       "      <td>2024-02-01</td>\n",
       "      <td>1.7753</td>\n",
       "      <td>1.8572</td>\n",
       "      <td>1.8802</td>\n",
       "      <td>2.2107</td>\n",
       "      <td>2.3048</td>\n",
       "      <td>2.4215</td>\n",
       "      <td>2.4354</td>\n",
       "      <td>2.6472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>中债国债收益率曲线</td>\n",
       "      <td>2024-02-02</td>\n",
       "      <td>1.7718</td>\n",
       "      <td>1.8782</td>\n",
       "      <td>1.8903</td>\n",
       "      <td>2.1886</td>\n",
       "      <td>2.2799</td>\n",
       "      <td>2.4115</td>\n",
       "      <td>2.4244</td>\n",
       "      <td>2.6353</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>中债中短期票据收益率曲线(AAA)</td>\n",
       "      <td>2024-02-02</td>\n",
       "      <td>2.4123</td>\n",
       "      <td>2.4250</td>\n",
       "      <td>2.4422</td>\n",
       "      <td>2.5868</td>\n",
       "      <td>2.7527</td>\n",
       "      <td>2.7680</td>\n",
       "      <td>2.7951</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>739</th>\n",
       "      <td>中债商业银行普通债收益率曲线(AAA)</td>\n",
       "      <td>2025-01-26</td>\n",
       "      <td>1.8752</td>\n",
       "      <td>1.7809</td>\n",
       "      <td>1.7653</td>\n",
       "      <td>1.7485</td>\n",
       "      <td>1.8082</td>\n",
       "      <td>1.8759</td>\n",
       "      <td>1.9211</td>\n",
       "      <td>2.1647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>740</th>\n",
       "      <td>中债国债收益率曲线</td>\n",
       "      <td>2025-01-26</td>\n",
       "      <td>1.4196</td>\n",
       "      <td>1.3911</td>\n",
       "      <td>1.3474</td>\n",
       "      <td>1.3337</td>\n",
       "      <td>1.4557</td>\n",
       "      <td>1.5873</td>\n",
       "      <td>1.6537</td>\n",
       "      <td>1.8910</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>741</th>\n",
       "      <td>中债中短期票据收益率曲线(AAA)</td>\n",
       "      <td>2025-01-27</td>\n",
       "      <td>1.9003</td>\n",
       "      <td>1.8556</td>\n",
       "      <td>1.8016</td>\n",
       "      <td>1.8418</td>\n",
       "      <td>1.8978</td>\n",
       "      <td>1.9534</td>\n",
       "      <td>2.0105</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>742</th>\n",
       "      <td>中债商业银行普通债收益率曲线(AAA)</td>\n",
       "      <td>2025-01-27</td>\n",
       "      <td>1.7728</td>\n",
       "      <td>1.7724</td>\n",
       "      <td>1.7419</td>\n",
       "      <td>1.7206</td>\n",
       "      <td>1.7800</td>\n",
       "      <td>1.8628</td>\n",
       "      <td>1.9072</td>\n",
       "      <td>2.1647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>743</th>\n",
       "      <td>中债国债收益率曲线</td>\n",
       "      <td>2025-01-27</td>\n",
       "      <td>1.3775</td>\n",
       "      <td>1.3600</td>\n",
       "      <td>1.3036</td>\n",
       "      <td>1.3108</td>\n",
       "      <td>1.4124</td>\n",
       "      <td>1.5484</td>\n",
       "      <td>1.6299</td>\n",
       "      <td>1.8675</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>744 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    曲线名称          日期      3月      6月      1年      3年      5年  \\\n",
       "0      中债中短期票据收益率曲线(AAA)  2024-02-01  2.4291  2.4349  2.4409  2.5881  2.7571   \n",
       "1    中债商业银行普通债收益率曲线(AAA)  2024-02-01  2.3186  2.3284  2.3762  2.5096  2.6316   \n",
       "2              中债国债收益率曲线  2024-02-01  1.7753  1.8572  1.8802  2.2107  2.3048   \n",
       "3              中债国债收益率曲线  2024-02-02  1.7718  1.8782  1.8903  2.1886  2.2799   \n",
       "4      中债中短期票据收益率曲线(AAA)  2024-02-02  2.4123  2.4250  2.4422  2.5868  2.7527   \n",
       "..                   ...         ...     ...     ...     ...     ...     ...   \n",
       "739  中债商业银行普通债收益率曲线(AAA)  2025-01-26  1.8752  1.7809  1.7653  1.7485  1.8082   \n",
       "740            中债国债收益率曲线  2025-01-26  1.4196  1.3911  1.3474  1.3337  1.4557   \n",
       "741    中债中短期票据收益率曲线(AAA)  2025-01-27  1.9003  1.8556  1.8016  1.8418  1.8978   \n",
       "742  中债商业银行普通债收益率曲线(AAA)  2025-01-27  1.7728  1.7724  1.7419  1.7206  1.7800   \n",
       "743            中债国债收益率曲线  2025-01-27  1.3775  1.3600  1.3036  1.3108  1.4124   \n",
       "\n",
       "         7年     10年     30年  \n",
       "0    2.7725  2.8000     NaN  \n",
       "1    2.6515  2.6900  2.9507  \n",
       "2    2.4215  2.4354  2.6472  \n",
       "3    2.4115  2.4244  2.6353  \n",
       "4    2.7680  2.7951     NaN  \n",
       "..      ...     ...     ...  \n",
       "739  1.8759  1.9211  2.1647  \n",
       "740  1.5873  1.6537  1.8910  \n",
       "741  1.9534  2.0105     NaN  \n",
       "742  1.8628  1.9072  2.1647  \n",
       "743  1.5484  1.6299  1.8675  \n",
       "\n",
       "[744 rows x 10 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bond_china_yield_df = ak.bond_china_yield(start_date=\"20240201\", end_date=\"20250201\")\n",
    "bond_china_yield_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "0f5a10ac",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.microsoft.datawrangler.viewer.v0+json": {
       "columns": [
        {
         "name": "index",
         "rawType": "int64",
         "type": "integer"
        },
        {
         "name": "曲线名称",
         "rawType": "object",
         "type": "string"
        },
        {
         "name": "日期",
         "rawType": "object",
         "type": "unknown"
        },
        {
         "name": "3月",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "6月",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "1年",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "3年",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "5年",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "7年",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "10年",
         "rawType": "float64",
         "type": "float"
        },
        {
         "name": "30年",
         "rawType": "float64",
         "type": "float"
        }
       ],
       "ref": "14866ac8-50cc-47a4-b05d-71866e13e6bf",
       "rows": [
        [
         "2",
         "中债国债收益率曲线",
         "2024-02-01",
         "1.7753",
         "1.8572",
         "1.8802",
         "2.2107",
         "2.3048",
         "2.4215",
         "2.4354",
         "2.6472"
        ],
        [
         "3",
         "中债国债收益率曲线",
         "2024-02-02",
         "1.7718",
         "1.8782",
         "1.8903",
         "2.1886",
         "2.2799",
         "2.4115",
         "2.4244",
         "2.6353"
        ],
        [
         "6",
         "中债国债收益率曲线",
         "2024-02-04",
         "1.7718",
         "1.8738",
         "1.8803",
         "2.1743",
         "2.2728",
         "2.3961",
         "2.4053",
         "2.6076"
        ],
        [
         "9",
         "中债国债收益率曲线",
         "2024-02-05",
         "1.7505",
         "1.8445",
         "1.8829",
         "2.1887",
         "2.2751",
         "2.3978",
         "2.4002",
         "2.5974"
        ],
        [
         "14",
         "中债国债收益率曲线",
         "2024-02-06",
         "1.7558",
         "1.8518",
         "1.9269",
         "2.2405",
         "2.3329",
         "2.4503",
         "2.4525",
         "2.6579"
        ],
        [
         "17",
         "中债国债收益率曲线",
         "2024-02-07",
         "1.744",
         "1.8511",
         "1.9287",
         "2.1864",
         "2.2985",
         "2.415",
         "2.4153",
         "2.6214"
        ],
        [
         "19",
         "中债国债收益率曲线",
         "2024-02-08",
         "1.7277",
         "1.8541",
         "1.9265",
         "2.1891",
         "2.2885",
         "2.4353",
         "2.4379",
         "2.6505"
        ],
        [
         "23",
         "中债国债收益率曲线",
         "2024-02-09",
         "1.7127",
         "1.8481",
         "1.9265",
         "2.1891",
         "2.2885",
         "2.43",
         "2.4302",
         "2.6505"
        ],
        [
         "24",
         "中债国债收益率曲线",
         "2024-02-18",
         "1.687",
         "1.8593",
         "1.9292",
         "2.1884",
         "2.2972",
         "2.4356",
         "2.4393",
         "2.643"
        ],
        [
         "27",
         "中债国债收益率曲线",
         "2024-02-19",
         "1.6713",
         "1.8779",
         "1.9157",
         "2.1909",
         "2.3058",
         "2.4263",
         "2.4344",
         "2.627"
        ],
        [
         "32",
         "中债国债收益率曲线",
         "2024-02-20",
         "1.6632",
         "1.7937",
         "1.8649",
         "2.1634",
         "2.2759",
         "2.4041",
         "2.4134",
         "2.6004"
        ],
        [
         "35",
         "中债国债收益率曲线",
         "2024-02-21",
         "1.6017",
         "1.7497",
         "1.8149",
         "2.1634",
         "2.2683",
         "2.4018",
         "2.4119",
         "2.601"
        ],
        [
         "38",
         "中债国债收益率曲线",
         "2024-02-22",
         "1.6052",
         "1.744",
         "1.7731",
         "2.1284",
         "2.2439",
         "2.3835",
         "2.4033",
         "2.591"
        ],
        [
         "39",
         "中债国债收益率曲线",
         "2024-02-23",
         "1.5512",
         "1.7215",
         "1.7699",
         "2.1234",
         "2.2495",
         "2.381",
         "2.4009",
         "2.5809"
        ],
        [
         "44",
         "中债国债收益率曲线",
         "2024-02-26",
         "1.5512",
         "1.7129",
         "1.767",
         "2.1134",
         "2.2244",
         "2.3629",
         "2.3789",
         "2.54"
        ],
        [
         "47",
         "中债国债收益率曲线",
         "2024-02-27",
         "1.5855",
         "1.6785",
         "1.7739",
         "2.1334",
         "2.2419",
         "2.3675",
         "2.3809",
         "2.5224"
        ],
        [
         "48",
         "中债国债收益率曲线",
         "2024-02-28",
         "1.6625",
         "1.7031",
         "1.7863",
         "2.1103",
         "2.2223",
         "2.34",
         "2.3376",
         "2.4868"
        ],
        [
         "51",
         "中债国债收益率曲线",
         "2024-02-29",
         "1.6454",
         "1.6939",
         "1.7871",
         "2.1005",
         "2.2178",
         "2.34",
         "2.3375",
         "2.4616"
        ],
        [
         "54",
         "中债国债收益率曲线",
         "2024-03-01",
         "1.628",
         "1.6885",
         "1.7833",
         "2.1405",
         "2.2632",
         "2.3799",
         "2.3675",
         "2.4915"
        ],
        [
         "59",
         "中债国债收益率曲线",
         "2024-03-04",
         "1.6055",
         "1.6643",
         "1.7612",
         "2.123",
         "2.2489",
         "2.3569",
         "2.3475",
         "2.4738"
        ],
        [
         "62",
         "中债国债收益率曲线",
         "2024-03-05",
         "1.5955",
         "1.7017",
         "1.7732",
         "2.1108",
         "2.2285",
         "2.3358",
         "2.3169",
         "2.4794"
        ],
        [
         "63",
         "中债国债收益率曲线",
         "2024-03-06",
         "1.6006",
         "1.7026",
         "1.7574",
         "2.0708",
         "2.1675",
         "2.2828",
         "2.265",
         "2.4274"
        ],
        [
         "68",
         "中债国债收益率曲线",
         "2024-03-07",
         "1.5809",
         "1.6528",
         "1.7578",
         "2.0857",
         "2.1959",
         "2.2973",
         "2.2776",
         "2.431"
        ],
        [
         "71",
         "中债国债收益率曲线",
         "2024-03-08",
         "1.5819",
         "1.6641",
         "1.7525",
         "2.0906",
         "2.2089",
         "2.3023",
         "2.2825",
         "2.4335"
        ],
        [
         "72",
         "中债国债收益率曲线",
         "2024-03-11",
         "1.6056",
         "1.6655",
         "1.7575",
         "2.111",
         "2.232",
         "2.3198",
         "2.305",
         "2.4766"
        ],
        [
         "75",
         "中债国债收益率曲线",
         "2024-03-12",
         "1.5931",
         "1.6673",
         "1.7975",
         "2.1517",
         "2.2716",
         "2.3598",
         "2.3476",
         "2.5415"
        ],
        [
         "80",
         "中债国债收益率曲线",
         "2024-03-13",
         "1.6237",
         "1.6762",
         "1.8175",
         "2.1548",
         "2.2587",
         "2.3448",
         "2.3326",
         "2.5313"
        ],
        [
         "83",
         "中债国债收益率曲线",
         "2024-03-14",
         "1.6437",
         "1.6969",
         "1.8475",
         "2.1528",
         "2.2595",
         "2.3672",
         "2.3425",
         "2.5343"
        ],
        [
         "85",
         "中债国债收益率曲线",
         "2024-03-15",
         "1.6537",
         "1.6907",
         "1.8325",
         "2.1276",
         "2.2428",
         "2.3496",
         "2.32",
         "2.5094"
        ],
        [
         "89",
         "中债国债收益率曲线",
         "2024-03-18",
         "1.6724",
         "1.6813",
         "1.7825",
         "2.0812",
         "2.2168",
         "2.3294",
         "2.2926",
         "2.4857"
        ],
        [
         "90",
         "中债国债收益率曲线",
         "2024-03-19",
         "1.6739",
         "1.6873",
         "1.7725",
         "2.0742",
         "2.2074",
         "2.3154",
         "2.2801",
         "2.4485"
        ],
        [
         "93",
         "中债国债收益率曲线",
         "2024-03-20",
         "1.6658",
         "1.6835",
         "1.7725",
         "2.0828",
         "2.2233",
         "2.3369",
         "2.2951",
         "2.466"
        ],
        [
         "96",
         "中债国债收益率曲线",
         "2024-03-21",
         "1.6412",
         "1.7004",
         "1.7625",
         "2.063",
         "2.2036",
         "2.322",
         "2.2851",
         "2.4615"
        ],
        [
         "101",
         "中债国债收益率曲线",
         "2024-03-22",
         "1.6403",
         "1.6952",
         "1.7625",
         "2.0695",
         "2.2143",
         "2.337",
         "2.3051",
         "2.4832"
        ],
        [
         "104",
         "中债国债收益率曲线",
         "2024-03-25",
         "1.65",
         "1.7073",
         "1.7875",
         "2.0793",
         "2.2281",
         "2.3543",
         "2.3151",
         "2.4962"
        ],
        [
         "105",
         "中债国债收益率曲线",
         "2024-03-26",
         "1.6365",
         "1.6829",
         "1.79",
         "2.08",
         "2.2279",
         "2.3593",
         "2.3175",
         "2.4982"
        ],
        [
         "109",
         "中债国债收益率曲线",
         "2024-03-27",
         "1.6408",
         "1.6679",
         "1.7525",
         "2.0545",
         "2.1948",
         "2.32",
         "2.2876",
         "2.4636"
        ],
        [
         "113",
         "中债国债收益率曲线",
         "2024-03-28",
         "1.6411",
         "1.6685",
         "1.7525",
         "2.0549",
         "2.2112",
         "2.33",
         "2.3026",
         "2.4664"
        ],
        [
         "116",
         "中债国债收益率曲线",
         "2024-03-29",
         "1.6414",
         "1.6591",
         "1.7225",
         "2.0315",
         "2.1974",
         "2.3175",
         "2.2901",
         "2.4594"
        ],
        [
         "117",
         "中债国债收益率曲线",
         "2024-04-01",
         "1.6333",
         "1.6464",
         "1.7425",
         "2.0643",
         "2.2172",
         "2.3375",
         "2.3082",
         "2.4848"
        ],
        [
         "122",
         "中债国债收益率曲线",
         "2024-04-02",
         "1.6202",
         "1.6329",
         "1.7275",
         "2.0553",
         "2.1967",
         "2.3225",
         "2.2927",
         "2.475"
        ],
        [
         "125",
         "中债国债收益率曲线",
         "2024-04-03",
         "1.6122",
         "1.6249",
         "1.7225",
         "2.0428",
         "2.1897",
         "2.31",
         "2.2837",
         "2.4635"
        ],
        [
         "128",
         "中债国债收益率曲线",
         "2024-04-07",
         "1.6102",
         "1.6189",
         "1.7225",
         "2.0446",
         "2.1946",
         "2.3175",
         "2.2937",
         "2.4776"
        ],
        [
         "129",
         "中债国债收益率曲线",
         "2024-04-08",
         "1.5892",
         "1.5988",
         "1.7025",
         "2.02",
         "2.169",
         "2.3",
         "2.2822",
         "2.4656"
        ],
        [
         "134",
         "中债国债收益率曲线",
         "2024-04-09",
         "1.5792",
         "1.5848",
         "1.6925",
         "2.0183",
         "2.1533",
         "2.295",
         "2.2802",
         "2.4637"
        ],
        [
         "137",
         "中债国债收益率曲线",
         "2024-04-10",
         "1.5601",
         "1.6148",
         "1.7033",
         "2.0187",
         "2.1591",
         "2.3025",
         "2.2972",
         "2.4891"
        ],
        [
         "140",
         "中债国债收益率曲线",
         "2024-04-11",
         "1.5501",
         "1.6084",
         "1.7033",
         "2.0164",
         "2.1378",
         "2.2901",
         "2.2928",
         "2.4928"
        ],
        [
         "141",
         "中债国债收益率曲线",
         "2024-04-12",
         "1.5502",
         "1.6051",
         "1.6958",
         "1.9925",
         "2.1119",
         "2.2583",
         "2.2837",
         "2.487"
        ],
        [
         "146",
         "中债国债收益率曲线",
         "2024-04-15",
         "1.5407",
         "1.6051",
         "1.7033",
         "2.0135",
         "2.1263",
         "2.254",
         "2.2798",
         "2.4863"
        ],
        [
         "149",
         "中债国债收益率曲线",
         "2024-04-16",
         "1.541",
         "1.6156",
         "1.7233",
         "2.0212",
         "2.1288",
         "2.2447",
         "2.2723",
         "2.4717"
        ]
       ],
       "shape": {
        "columns": 10,
        "rows": 248
       }
      },
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>曲线名称</th>\n",
       "      <th>日期</th>\n",
       "      <th>3月</th>\n",
       "      <th>6月</th>\n",
       "      <th>1年</th>\n",
       "      <th>3年</th>\n",
       "      <th>5年</th>\n",
       "      <th>7年</th>\n",
       "      <th>10年</th>\n",
       "      <th>30年</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>中债国债收益率曲线</td>\n",
       "      <td>2024-02-01</td>\n",
       "      <td>1.7753</td>\n",
       "      <td>1.8572</td>\n",
       "      <td>1.8802</td>\n",
       "      <td>2.2107</td>\n",
       "      <td>2.3048</td>\n",
       "      <td>2.4215</td>\n",
       "      <td>2.4354</td>\n",
       "      <td>2.6472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>中债国债收益率曲线</td>\n",
       "      <td>2024-02-02</td>\n",
       "      <td>1.7718</td>\n",
       "      <td>1.8782</td>\n",
       "      <td>1.8903</td>\n",
       "      <td>2.1886</td>\n",
       "      <td>2.2799</td>\n",
       "      <td>2.4115</td>\n",
       "      <td>2.4244</td>\n",
       "      <td>2.6353</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>中债国债收益率曲线</td>\n",
       "      <td>2024-02-04</td>\n",
       "      <td>1.7718</td>\n",
       "      <td>1.8738</td>\n",
       "      <td>1.8803</td>\n",
       "      <td>2.1743</td>\n",
       "      <td>2.2728</td>\n",
       "      <td>2.3961</td>\n",
       "      <td>2.4053</td>\n",
       "      <td>2.6076</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>中债国债收益率曲线</td>\n",
       "      <td>2024-02-05</td>\n",
       "      <td>1.7505</td>\n",
       "      <td>1.8445</td>\n",
       "      <td>1.8829</td>\n",
       "      <td>2.1887</td>\n",
       "      <td>2.2751</td>\n",
       "      <td>2.3978</td>\n",
       "      <td>2.4002</td>\n",
       "      <td>2.5974</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>中债国债收益率曲线</td>\n",
       "      <td>2024-02-06</td>\n",
       "      <td>1.7558</td>\n",
       "      <td>1.8518</td>\n",
       "      <td>1.9269</td>\n",
       "      <td>2.2405</td>\n",
       "      <td>2.3329</td>\n",
       "      <td>2.4503</td>\n",
       "      <td>2.4525</td>\n",
       "      <td>2.6579</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>731</th>\n",
       "      <td>中债国债收益率曲线</td>\n",
       "      <td>2025-01-22</td>\n",
       "      <td>1.4051</td>\n",
       "      <td>1.3764</td>\n",
       "      <td>1.2850</td>\n",
       "      <td>1.2810</td>\n",
       "      <td>1.4257</td>\n",
       "      <td>1.5652</td>\n",
       "      <td>1.6602</td>\n",
       "      <td>1.9000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>734</th>\n",
       "      <td>中债国债收益率曲线</td>\n",
       "      <td>2025-01-23</td>\n",
       "      <td>1.4135</td>\n",
       "      <td>1.3869</td>\n",
       "      <td>1.3099</td>\n",
       "      <td>1.3028</td>\n",
       "      <td>1.4557</td>\n",
       "      <td>1.5850</td>\n",
       "      <td>1.6645</td>\n",
       "      <td>1.9000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>735</th>\n",
       "      <td>中债国债收益率曲线</td>\n",
       "      <td>2025-01-24</td>\n",
       "      <td>1.4416</td>\n",
       "      <td>1.4109</td>\n",
       "      <td>1.3399</td>\n",
       "      <td>1.3437</td>\n",
       "      <td>1.4657</td>\n",
       "      <td>1.5873</td>\n",
       "      <td>1.6565</td>\n",
       "      <td>1.8900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>740</th>\n",
       "      <td>中债国债收益率曲线</td>\n",
       "      <td>2025-01-26</td>\n",
       "      <td>1.4196</td>\n",
       "      <td>1.3911</td>\n",
       "      <td>1.3474</td>\n",
       "      <td>1.3337</td>\n",
       "      <td>1.4557</td>\n",
       "      <td>1.5873</td>\n",
       "      <td>1.6537</td>\n",
       "      <td>1.8910</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>743</th>\n",
       "      <td>中债国债收益率曲线</td>\n",
       "      <td>2025-01-27</td>\n",
       "      <td>1.3775</td>\n",
       "      <td>1.3600</td>\n",
       "      <td>1.3036</td>\n",
       "      <td>1.3108</td>\n",
       "      <td>1.4124</td>\n",
       "      <td>1.5484</td>\n",
       "      <td>1.6299</td>\n",
       "      <td>1.8675</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>248 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          曲线名称          日期      3月      6月      1年      3年      5年      7年  \\\n",
       "2    中债国债收益率曲线  2024-02-01  1.7753  1.8572  1.8802  2.2107  2.3048  2.4215   \n",
       "3    中债国债收益率曲线  2024-02-02  1.7718  1.8782  1.8903  2.1886  2.2799  2.4115   \n",
       "6    中债国债收益率曲线  2024-02-04  1.7718  1.8738  1.8803  2.1743  2.2728  2.3961   \n",
       "9    中债国债收益率曲线  2024-02-05  1.7505  1.8445  1.8829  2.1887  2.2751  2.3978   \n",
       "14   中债国债收益率曲线  2024-02-06  1.7558  1.8518  1.9269  2.2405  2.3329  2.4503   \n",
       "..         ...         ...     ...     ...     ...     ...     ...     ...   \n",
       "731  中债国债收益率曲线  2025-01-22  1.4051  1.3764  1.2850  1.2810  1.4257  1.5652   \n",
       "734  中债国债收益率曲线  2025-01-23  1.4135  1.3869  1.3099  1.3028  1.4557  1.5850   \n",
       "735  中债国债收益率曲线  2025-01-24  1.4416  1.4109  1.3399  1.3437  1.4657  1.5873   \n",
       "740  中债国债收益率曲线  2025-01-26  1.4196  1.3911  1.3474  1.3337  1.4557  1.5873   \n",
       "743  中债国债收益率曲线  2025-01-27  1.3775  1.3600  1.3036  1.3108  1.4124  1.5484   \n",
       "\n",
       "        10年     30年  \n",
       "2    2.4354  2.6472  \n",
       "3    2.4244  2.6353  \n",
       "6    2.4053  2.6076  \n",
       "9    2.4002  2.5974  \n",
       "14   2.4525  2.6579  \n",
       "..      ...     ...  \n",
       "731  1.6602  1.9000  \n",
       "734  1.6645  1.9000  \n",
       "735  1.6565  1.8900  \n",
       "740  1.6537  1.8910  \n",
       "743  1.6299  1.8675  \n",
       "\n",
       "[248 rows x 10 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bond_china_yield_df[bond_china_yield_df['曲线名称']=='中债国债收益率曲线']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "2cc4cd6a",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "fas",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
